how do I turn rows into columns

[Guest]

I'm copy and pasting a list into Excel. Excel automatically takes my list
and puts each item into the next row. What I want to do is have each row be
the heading of a column instead. So how to I get the table to reverse
itself, so items in rows go into columns, and the columns become rows instead?

 

[CLR]

Copy > PasteSpecial > Transpose > ok..................

Vaya con Dios,
Chuck, CABGx3

I'm copy and pasting a list into Excel. Excel automatically takes my list
and puts each item into the next row. What I want to do is have each row be
the heading of a column instead. So how to I get the table to reverse
itself, so items in rows go into columns, and the columns become rows

instead?

 

[Guest]

Try this:

Copy the cells then select
Edit>Paste Special
then select the Transpose check box right above the OK button then hit OK.

Hope this helps.