I imported data from a spread sheet that comes from a program at work. so the table looks like what I have attached. I want the numbers to be the column headings so I can add info under them. Thank you again for your time.
I know this is probably a easy question for you all but I for the life of me can't figure out the SQL in the query. I have a table with one field in it. I want it do the following.
Field1
A
B
C
A B C (column headings)
The table name is HSC. Thank you for your time.