Transpose Feature Inop

D

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
 
O

Otto Moehrbach

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

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
 
Top