interchange rows and columns

[Guest]

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!

 

[Peo Sjoblom]

If you have less than 256 rows, copy the data, go to a new sheet and do
edit>paste 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

 

[Guest]

Thanks!

If you have less than 256 rows, copy the data, go to a new sheet and do
edit>paste 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

 

[Ken Wright]

If you want to stay on the same sheet you have to ensure the copied range
and the pasted range do not overlap.