How do change rows to colums AND columns to rows

[Guest]

I need to change the whole orientation of my spreadsheets... columns to rows
AND rows to columns - does anyone know of a quick way, or do I have to
transpose all the information individually.

Thanks

 

[Guest]

Have you tried this?:

Select your range
Edit>Copy
Select a cell outside of your range
Edit>Paste Special>Transpose

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[TJS]

Hi,

Copy, then Paste Special Transpose.

 

[Guest]

Hi,

Maybe there is a more elegant way of accomplishinging what you want. But
the following approach should work.

Let's assume that your data are in Sheet1.

Create a blank worksheet ("Insert" --> "Worksheet").

In A1 of that worksheet, enter the following formula, and auto-fill across
columns and down rows, to accommodate the transposed data.

=IF(OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1)="","",OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1))

The new sheet is still linked to the original sheet. To make it
stand-alone, select and copy the entire area of the new sheet, then "Edit"
--> "Paste Special" --> "Values" --> "OK"

Regards,
B. R. Ramachandran

 

[Guest]

Many thanks - I'll try this

Colleen

Hi,

Maybe there is a more elegant way of accomplishinging what you want. But
the following approach should work.

Let's assume that your data are in Sheet1.

Create a blank worksheet ("Insert" --> "Worksheet").

In A1 of that worksheet, enter the following formula, and auto-fill across
columns and down rows, to accommodate the transposed data.

=IF(OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1)="","",OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1))

The new sheet is still linked to the original sheet. To make it
stand-alone, select and copy the entire area of the new sheet, then "Edit"
--> "Paste Special" --> "Values" --> "OK"

Regards,
B. R. Ramachandran

 

[Guest]

Thanks - of course this seems to lose all formats, but I guess I can re-do
them.

Colleen

 

[Guest]

Thanks - I tried this but it changed all formats also - of course, I can
always re-enter, right

Colleen

 

[Peo Sjoblom]

No it will carry the formatting as well unless you select otherwise

--
Regards,

Peo Sjoblom

(No private emails please)