Home |
Search |
Today's Posts |
#1
|
|||
|
|||
In Excel, how do I change the rows into columns?
Current spreadsheet
a b c l m n x y z Desired spreadsheet a l x b m y c n z |
#2
|
|||
|
|||
Copy the cells, move somewhere else on the sheet or to another sheet, select
Paste Special | Transpose regards Trevor "Novice SS User" <Novice SS wrote in message ... Current spreadsheet a b c l m n x y z Desired spreadsheet a l x b m y c n z |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the columns in excel back to alpha characters? | Setting up and Configuration of Excel | |||
interchange columns with rows | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Rows and columns | New Users to Excel | |||
sumif columns and rows | Excel Worksheet Functions |