Changing a 1 Row Table to 2 Column Table

[ABBB71704]

I need to transpose a table of 1 row in to 2 columns, where the current
column headers would be in the 1st row and the 1 row of data would be a
second column.

For example:
Col1 Col2 Col3 Col4
AA BB CC DD

Needs to be
Name Letters
Col1 AA
Col2 BB
Col3 CC
Col4 DD

Is there a simple way to do this? The number of records currently as Column
titles will vary, and I need to do this several times.

Thanks

 

[Jeff C]

I would link to that table from Excel and use the transpose columns feature
in "Paste Special". Then in Access get external data, link to that table you
transposed in Excel. Use a make table query to bring the data back into
Access if you need to otherwise just work with the data on the linked table.

 

[ABBB71704]

Is there any way to do this automatically? Like using sql code? I need this
to be a fairly dynamic process, and I would like to avoid any manual steps.

Thanks for the help!

 

[Jeff C]

Once you link your Access table to Excel you can build a macro to copy and
paste special, transpose etc. Once you link this to Access you can sequence
your make table query.