On Fri, 28 Nov 2008 18:21:01 -0800, Mimi
wrote:

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