Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to exchange rows and columns?
Hello all,
Does anyone know how to exchange rows for columns and vice versa without creating a pivot table? ex: Red Green Blue Jim 1 2 3 Joe 4 5 6 Changed to Jim Joe Red 1 4 Green 2 5 Blue 3 6 THANKS! Scott |
#2
|
|||
|
|||
Hi
select your data and copy it click where you want the reversed list (must be outside the selected range) and choose edit / paste special - transpose the original data can then be deleted if you wish. Cheers julieD "scorwitz" wrote in message ... Hello all, Does anyone know how to exchange rows for columns and vice versa without creating a pivot table? ex: Red Green Blue Jim 1 2 3 Joe 4 5 6 Changed to Jim Joe Red 1 4 Green 2 5 Blue 3 6 THANKS! Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing problems with columns and rows | Excel Discussion (Misc queries) | |||
Can I rotate excel sheets so columns are rows & vice-versa (i.e.. | 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 |