+++Switch Rows & Columns

[Ian]

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]

Copy, Edit, Paste Special, Transpose.