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

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

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.

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

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