Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I turn rows into columns
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? |
#2
|
|||
|
|||
Copy PasteSpecial Transpose ok..................
Vaya con Dios, Chuck, CABGx3 "Madigan" wrote in message ... 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? |
#3
|
|||
|
|||
Try this:
Copy the cells then select EditPaste Special then select the Transpose check box right above the OK button then hit OK. Hope this helps. "Madigan" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Converting Columns to Rows | Excel Worksheet Functions | |||
How do I lookup values from rows and columns Simultaneously | Excel Worksheet Functions | |||
How to keep rows together when sorting columns? | Excel Worksheet Functions | |||
Printing problems with columns and rows | Excel Discussion (Misc queries) |