Transposing a whole table

[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?

 

[Guest]

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.

 

[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.