Can I rotate my spreadsheet?

[LAS]

I have a simple spreadsheet, one set of rows and columns. I would like to
re-organize it so the rows become the columns and the columns become the
rows. Is this possible?

 

[Dave Peterson]

Maybe -- if you have enough room.

If your data has 56,789 rows, then there won't be enough columns in any version
of excel to transpose the rows into columns.

But assuming that you do.
Create a new worksheet
Select the range on the old worksheet
Edit|Copy (in xl2003 menus)
Select A1 on that new sheet
Edit|Paste special|Check Transpose and click ok

 

[LAS]

Perfect!! Thanks!

Maybe -- if you have enough room.

If your data has 56,789 rows, then there won't be enough columns in any
version of excel to transpose the rows into columns.

But assuming that you do.
Create a new worksheet
Select the range on the old worksheet
Edit|Copy (in xl2003 menus)
Select A1 on that new sheet
Edit|Paste special|Check Transpose and click ok