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]

Thanks a lot, Niek.