Switching Row & Column Headers

[Greta]

I have a whole bunch of data. The rows should actually be
the columns, and Column A should be the column
headers....make sense? Like this:
Name Aname Bname Cname Dname
Number 44 55 66 77
Letter ftr ftg fth fkk

should Be:
Name Number Letter
Aname 44 ftr
Bname 55 ftg
Cname 66 fth
Dname 77 fkk

How do can I easily switch them?
Thanks,
Greta

 

[Frank Kabel]

Hi Greta
try the following:
- Select your cells and copy them (CTRL+C)
- Select your target area
- Goto 'Edit - Paste Special' and choose 'Transpose'
- Hit 'OK'

Frank

 

[Niek Otten]

Hi Greta,

Look in Help for details on Edit>Paste Special>Transpose

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel