Transpose Feature Inop
 

I need to transpose 611 cells of data from a column to a row. Excel (07)
returns an error message that the cells are not the same size and shape. I
do not know why that should matter, because Excel has a capacity of over
16,000 columns. What am I missing here?

DOUG

Transpose Feature Inop
 

Are some of these cells merged cells? That's what the error sounds like.
HTH Otto
"DOUG ECKERT" wrote in message
...
I need to transpose 611 cells of data from a column to a row. Excel (07)
returns an error message that the cells are not the same size and shape.
I
do not know why that should matter, because Excel has a capacity of over
16,000 columns. What am I missing here?

DOUG

Transpose Feature Inop
 

Otto: Thank you for writing back to me.

No, I do not believe so. But, I did find the maximum number of columns to
be 258 (!). So, I divided my process into three clusters and it worked fine.

DOUG

"Otto Moehrbach" wrote:

Are some of these cells merged cells? That's what the error sounds like.
HTH Otto
"DOUG ECKERT" wrote in message
...
I need to transpose 611 cells of data from a column to a row. Excel (07)
returns an error message that the cells are not the same size and shape.
I
do not know why that should matter, because Excel has a capacity of over
16,000 columns. What am I missing here?

DOUG