Switching rows and columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Schraalhans Keukenmeester - 29 Dec 2006 18:40 GMT

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.

Reply to this Message

Dave Peterson - 29 Dec 2006 19:03 GMT

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.

> 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
[quoted text clipped - 4 lines]
> THANKS!
> Sh.

Signature

Dave Peterson

Reply to this Message

Gord Dibben - 29 Dec 2006 19:03 GMT

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

>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
[quoted text clipped - 4 lines]
>THANKS!
>Sh.

Reply to this Message

Schraalhans Keukenmeester - 01 Jan 2007 23:57 GMT

> Check out the word "Transpose" in Excel help.
>
[quoted text clipped - 19 lines]
>> THANKS!
>> Sh.

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.

Reply to this Message