Home |
Search |
Today's Posts |
#1
|
|||
|
|||
turn columns into rows
I have a large spreadsheet that I'd like to have in two separate formats:
One, with Data X in Columns and Data Y in Rows, the other with Data Y in Columns and Data X in Rows. How can I do this while preserving the data? |
#2
|
|||
|
|||
Select data, right click, choose "Copy".
Right click in first cell of new location, choose "Paste Special", and click on "Transpose", then <OK. Don't forget ... you only have 256 columns. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "chippy" wrote in message ... I have a large spreadsheet that I'd like to have in two separate formats: One, with Data X in Columns and Data Y in Rows, the other with Data Y in Columns and Data X in Rows. How can I do this while preserving the data? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing problems with columns and rows | Excel Discussion (Misc queries) | |||
Convert multiple columns to rows | Excel Worksheet Functions | |||
interchange columns with rows | Excel Discussion (Misc queries) | |||
Rows and columns | New Users to Excel | |||
sumif columns and rows | Excel Worksheet Functions |