Transpose column to row

[MaryamF]

I have a table with one Field and 83 records. I need to transpose this one column to 83 columns, so I would have a table with 83 columns and one row…. Is there any way to do this?
Appreciate
Maryam

 

[Darth Vodka]

are the entries all different? would a cross tab query then a make table query do it?

 

[neileg]

This sounds like the wrong thing to do. Can you explain why this seems neccesary?

If this is a one off, I would copy the data, paste/transpose in Excel and then import the Excel sheet as a new table.

 

[MaryamF]

Yes, the entries are all different, and I need to work on more than 1000 tables! So it's impossible to do it manually....

 

[neileg]

You are asking us to solve your solution. Why not explain your problem instead?