Switching rows and columns

[Schraalhans Keukenmeester]

I am quite sure, in a long forgotten history, Lotus 1-2-3 had an option
allowing one to switch column contents to rows and vice versa. I must be
looking for the wrong keywords in help and google, can someone tell me
how to swap rows and columns in excel? Alternatively, same question for
OpenOffice Calc, which I also work with...

THANKS!
Sh.

 

[Dave Peterson]

I don't use OO.

But in Excel, you can select your range to transpose.
then Edit|Copy
Then select the top left cell of the new range
edit|Paste special|check Transpose and then ok.

You'll have to make sure that there is no overlap between the two ranges.

 

[Gord Dibben]

Check out the word "Transpose" in Excel help.

Or just copy A1:A200 and select B1 and Edit>Paste Special>Transpose>OK>Esc

A1:A200 can then be deleted.

B1:GS1 contains the transposed data.

NOTE: unless using 2007 version you are limited to 256 columns when transposing
to one row.

Does that last sentence make sense?


Gord Dibben MS Excel MVP

 

[Schraalhans Keukenmeester]

Check out the word "Transpose" in Excel help.

Or just copy A1:A200 and select B1 and Edit>Paste Special>Transpose>OK>Esc

A1:A200 can then be deleted.

B1:GS1 contains the transposed data.

NOTE: unless using 2007 version you are limited to 256 columns when transposing
to one row.

Does that last sentence make sense?


Gord Dibben MS Excel MVP

Yup, Transpose was the one I was looking for. My tables don't come close
to that many columns (and no I am not using 2007, I have 2003.)

I have found the equivalent in OO as well. (Basically the same)

Thanks for both replies.