ExcelBanter - +++Switch Rows & Columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - +++Switch Rows & Columns (https://www.excelbanter.com/excel-worksheet-functions/138862-switch-rows-columns.html)

Ian

+++Switch Rows & Columns

I have a block of data, e.g. 30 rows and 20 columns. How do I switch them,
i.e. put the data A1-T1 to A1-A20, A2-T2 to B1-B20, A3-T3 to C1-C20 and so
on?

David Biddulph[_2_]

+++Switch Rows & Columns

Copy, Edit, Paste Special, Transpose.
--
David Biddulph

"Ian" wrote in message
...
I have a block of data, e.g. 30 rows and 20 columns. How do I switch them,
i.e. put the data A1-T1 to A1-A20, A2-T2 to B1-B20, A3-T3 to C1-C20 and
so
on?

All times are GMT +1. The time now is 01:11 PM.