How do you rotate a table of excel data from horizontal to vertic.

D

DavidEllis_97062

I just want to take a table of 2 rows by 100 columns and turn it into a 2
column table. How can I do this?
 
G

Guest

hi,
copy a row. Select a cell where you want to put the column.
edit>paste special>transpose.(towards the bottom of the
paste special form)
the row in now a column.
do that with the other row.
 
M

Myrna Larson

Select the whole set of cells (say it's A1:CV2), Edit/Copy it, then select A3,
Edit/Paste Special and select the Transpose option. Now you can delete rows
1:2.
 
Top