Transposing a whole table

Z

Zilla

I'm awayre of the transpose function. But is
there a way to transpose a "whole" table so
ALL its rows become columns, and all its
columns become rows?
 
J

Joel

You don't need a function to do this. Use can use Paste Special in the edit
menu. copy the table and the selectt Paste special. Select transpose.
 
M

Max

The limitation of tranposing - the rows to cols part of it - is of course
due to the 256 cols limit in xl2003 or lower. The no. of rows in the source
table that you want transposed cannot exceed 256.
 
Top