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" <[email protected]> wrote in message
news:[email protected]...
> 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