change rows to columns/columns to rows
 

Isn't there a way to change a spreadsheet so the column headers change to
rows and the row headers change to columns?
I have Excel 2003.
Thanks, Meenie

change rows to columns/columns to rows
 

Hi,

Select all your data,
Copy.
Select cell in which you want the top left cell of the transposed data to
appear.
Paste Special.
Tick the Transpose box.
OK.

Regards - Dave

change rows to columns/columns to rows
 

I tried that but it didn't work. I get this error message:
"The selection is not valid. There are several possible reasons

"Dave" wrote:

Hi,

Select all your data,
Copy.
Select cell in which you want the top left cell of the transposed data to
appear.
Paste Special.
Tick the Transpose box.
OK.

Regards - Dave

change rows to columns/columns to rows
 

Read the rest of the error message and you will get an idea of what you're doing
incorrectly.

Make sure your selected cell to copy to is not within the range you just copied
to transpose.

Do not select entire columns and try to transpose.

Not enough room across rows.


Gord Dibben MS Excel MVP



On Fri, 30 May 2008 07:21:01 -0700, Meenie
wrote:

I tried that but it didn't work. I get this error message:
"The selection is not valid. There are several possible reasons

"Dave" wrote:

Hi,

Select all your data,
Copy.
Select cell in which you want the top left cell of the transposed data to
appear.
Paste Special.
Tick the Transpose box.
OK.

Regards - Dave