How to exchange rows and columns?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,
Does anyone know how to exchange rows for columns and vice versa without
creating a pivot table? ex:
Red Green Blue
Jim 1 2 3
Joe 4 5 6

Changed to

Jim Joe
Red 1 4
Green 2 5
Blue 3 6

THANKS!
Scott
 
Hi

select your data and copy it
click where you want the reversed list (must be outside the selected range)
and choose edit / paste special - transpose
the original data can then be deleted if you wish.

Cheers
julieD
 
Back
Top