Hello,
I got sample data here in an Access single-column table. This data is similar to the original data extracted from a text file.
1
Jack
200000
58
CompanyA
""
2
Jane
180000
50
companyB
""
3
John
190000
53
CompanyC
""
4
Ken
160000
45
CompanyD
Now I need to transform this into a new table as...