Home |
Search |
Today's Posts |
#1
|
|||
|
|||
interchange rows and columns
I been building a spreadsheet to record data and would like to interchange
the rows and columns to make viewing easier (I want to make the row data become column data and the column data become row data). Thanks! |
#2
|
|||
|
|||
If you have less than 256 rows, copy the data, go to a new sheet and do
editpaste special and select transpose If you have more than 256 rows it can't be done, then you need to put it on multiple sheets since excel only have 256 columns -- Regards, Peo Sjoblom "Larry Heine" <Larry wrote in message ... I been building a spreadsheet to record data and would like to interchange the rows and columns to make viewing easier (I want to make the row data become column data and the column data become row data). Thanks! |
#3
|
|||
|
|||
Thanks!
"Peo Sjoblom" wrote: If you have less than 256 rows, copy the data, go to a new sheet and do editpaste special and select transpose If you have more than 256 rows it can't be done, then you need to put it on multiple sheets since excel only have 256 columns -- Regards, Peo Sjoblom "Larry Heine" <Larry wrote in message ... I been building a spreadsheet to record data and would like to interchange the rows and columns to make viewing easier (I want to make the row data become column data and the column data become row data). Thanks! |
#4
|
|||
|
|||
If you want to stay on the same sheet you have to ensure the copied range
and the pasted range do not overlap. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Peo Sjoblom" wrote in message ... If you have less than 256 rows, copy the data, go to a new sheet and do editpaste special and select transpose If you have more than 256 rows it can't be done, then you need to put it on multiple sheets since excel only have 256 columns -- Regards, Peo Sjoblom "Larry Heine" <Larry wrote in message ... I been building a spreadsheet to record data and would like to interchange the rows and columns to make viewing easier (I want to make the row data become column data and the column data become row data). Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
sumif columns and rows | Excel Worksheet Functions |