interchanging rows and columns

I

Ian Borland

How can I transform a whole worksheet so that the contents of the columns
and rows are interchanged? ie the contents of, say, column 1 become the
contents of row 1 etc.
 
L

Lewis Clark

Copy the entire working range. The in the desired area click on EDIT .. PASTE SPECIAL .. and choose transpose.
 
G

Gord Dibben

Good suggestion, but for OP.............a reminder.

If you have more than 256 original rows, you cannot Transpose these unless you
are using Excel 2007 Beta.

i.e. you cannot tramspose a matrix greater than 256 columns x 256 rows


Gord Dibben MS Excel MVP
 
I

Ian Borland

bewdy, thanks - easy as pie.
Copy the entire working range. The in the desired area click on EDIT ... PASTE SPECIAL .. and choose transpose.
 
Top