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

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?

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


-----Original Message-----
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?
.

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.


On Fri, 11 Feb 2005 10:35:16 -0800, "DavidEllis_97062"
wrote:

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?