How to exchange rows and columns?
 

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

"scorwitz" wrote in message
...
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