Transpose Feature Inop

  • Thread starter Thread starter DOUG ECKERT
  • Start date Start date
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
 
Are some of these cells merged cells? That's what the error sounds like.
HTH Otto
 
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
Transpose Large Column to Row 2
"Paste Special / Transpose" problem 3
Transpose Error 2
Transposing 3
Transpose, but how? 0
Transpose large column 3
transpose column to a row? 1

Back
Top