Transpose Funtion

[Mimi]

Does anyone know the max number of rows and columns (range) the transpose
function can convert? I have a large verticle dataset I want to turn
horizontal. 15,000 - 30,000 rows and 40 columns.
Thanks!

 

[Ron Rosenfeld]

Does anyone know the max number of rows and columns (range) the transpose
function can convert? I have a large verticle dataset I want to turn
horizontal. 15,000 - 30,000 rows and 40 columns.
Thanks!

I don't know much about this process, but I am aware of the following:

Depending on how you are doing this, you may run into certain limitations.

For array size problems, see MSKB Q177991
Also, there can be issues if any element is greater than 255 characters.

Also, prior to XL2007, XL had 256 columns. Even XL 2007 has only 16,384
columns which is fewer than the number of possible rows (30,000) in your
dataset.
--ron

 

[Shane Devenshire]

Hi,

You can't transpose 15,000 rows into columns unless you are using 2007, but
there are only 16,384 columns so that the max number of rows that could be
transposed. I have verified that =TRANSPOSE(Range) will transpose 16,384
rows to columns.

However, it runs into a problem somewhere between 81,920 - 98,304 cells.
The Transpose command has a limit somewhere between 114,618 - 131,002 cells.
This limit might be related to the available resources on my computer.

If this helps, please click the the Yes button

Cheers,
Shane Devenshire

Cheers,
Shane Devenshire