Transposing a whole table
 

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?

--
- Zilla
(Remove XSPAM)

Transposing a whole table
 

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.

"Zilla" wrote:

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?

--
- Zilla
(Remove XSPAM)

Transposing a whole table
 

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Zilla" wrote in message
...
I'm aware 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?

--
- Zilla
(Remove XSPAM)