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

EditCopy, select new location,
EditPaste Special, check Transpose

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

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

Thanks a lot, Niek.