swap column and row headers

  • Thread starter Thread starter Masri
  • Start date Start date
M

Masri

Hello,

Can someone please tell me how I can swap Row and Coloumn
headers in Excel keeping the corresponding data
consistent.

Thanks!
-Masri
 
Copy your data to a new worksheet (as a test) using Paste Special --
Transpose.

Rgds,
Andy
 
You can't, but you can swap the data round keeping the row and column headers consistent. Copy
the data, select a new cell outside your existing data range, then do Edit / Paste Special /
Tranpose. Now just delete the original data and move the new table to where the old data was.
 
Masri

Try out copy>paste special>Transpose. May be what you need. Limitation is
you cannot have more than 255 rows(less if you have more than one column).

i.e. 256 minus number of columns

Gord Dibben Excel MVP - XL97 SR2 & XL2002

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Thanks a lot! It worked!
-----Original Message-----
You can't, but you can swap the data round keeping the
Click to expand...
row and column headers consistent. Copy
the data, select a new cell outside your existing data
Click to expand...
range, then do Edit / Paste Special /
Tranpose. Now just delete the original data and move
Click to expand...
the new table to where the old data was.
 
Back
Top