Transpose Feature Inop

[DOUG ECKERT]

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

 

[Otto Moehrbach]

Are some of these cells merged cells? That's what the error sounds like.
HTH Otto

 

[DOUG ECKERT]

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