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.
edit>paste special>transpose.(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"
<[email protected]> 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?