swap column and row headers

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
 
A

Andy Brown

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

Rgds,
Andy
 
K

Ken Wright

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.
 
G

Gord Dibben

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
 
M

Masri Bakhil

Thanks a lot! It worked!
-----Original Message-----
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top