switch rows & columns?

[wcc]

Hello group,

Within a selection of cell ranges, is there a quick way to switch the
rows and columns? For example, change

1 A AA
2 B BB
3 C CC

to

1 2 3
A B C
AA BB CC

Thank you.

- wcc

[Niek Otten]

Edit>Copy, select new location,
Edit>Paste Special, check Transpose

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"wcc" <wccppp@gmail.com> wrote in message
news:1114452658.106617.294130@o13g2000cwo.googlegroups.com...
> Hello group,
>
> Within a selection of cell ranges, is there a quick way to switch the
> rows and columns? For example, change
>
> 1 A AA
> 2 B BB
> 3 C CC
>
> to
>
> 1 2 3
> A B C
> AA BB CC
>
> Thank you.
>
> - wcc
>

[wcc]

Thanks a lot, Niek.