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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transpose Appears to be Broken 4
"Paste Special / Transpose" problem 3
Transpose Large Column to Row 2
Transpose between sheets 4
transpose column to a row? 1
Transpose Error 2
Transpose large column 3
Transposing 3

Top