copy the 20 columns. right click in (presumably) cell a2 Paste Special
Transpose

"GKW in GA" wrote:

I have a spreadsheet that has 1 row with 20 columns. I would like to make it
1 column and 20 rows, where A1 = A1, B1 = A2, C1 = A3, etc. Is there a way to
do this, maybe a macro or formula or something?