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 follows
ID Name Salary Age Company
1 Jack 200000 58 CompanyA
2 Jane 180000 50 CompanyB
3 John 190000 53 CompanyC
4 Ken 160000 45 CompnayD
This is a tricky problem that I cannot seem to figure out.
I would appreciate any help/suggestion for resolution on this issue.
Thanks in advance.
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 follows
ID Name Salary Age Company
1 Jack 200000 58 CompanyA
2 Jane 180000 50 CompanyB
3 John 190000 53 CompanyC
4 Ken 160000 45 CompnayD
This is a tricky problem that I cannot seem to figure out.
I would appreciate any help/suggestion for resolution on this issue.
Thanks in advance.