exchange rows and colums in excel 97 1

[abds]

I have a spreadsheet that looks like this(3x6)
***
***
***
***
***
***
I want to exchange it to look like this(6x3)
******
******
******
is there a simple way to do this?

 

[wbishopjr]

Copy the first sheet 3*6 and paste it using "Paste Special" from the edit menu and choose "Transpose" checkbox on the dialogue box that pops up. You should end up with 6*3 in the end.

Good luck,
WB

 

[DaleWatson123321]

A bit of an "assist"...

If you attempt to "transpose" at the SAME location, you'll get an ERROR message.

After copying, you need to transpose on either:

1) A separate sheet, or
2) A range BELOW or to the SIDE of the existing range.

Finally, I suspect your 6x3 and 3x6 might be ONLY an "example" and that your data could be GREATER in size.

If that's the case, and IF your number of ROWS happens to be GREATER than 256, then you would encounter a problem with the LIMITATION of 256 columns when you transpose.

I know this is really "iffy", but I thought it might still be useful information to be reminded of.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca