Transpose Appears to be Broken

D

DOUG

I receive an error message "the rectangle is not the same size and shape"
when I try to transpose a column of data into a row. I do not recall this
happening before and I really, really need this feature to work.
'Suggestions, anyone?

DOUG
 
J

JE McGimpsey

Do you have any merged cells?

Do you have multiple cells selected when you attempt to Paste Special?
 
D

DOUG

Dear JE McGimpsey: I was attempting to transpose too many rows into too few
columns. MS Excel 07 has a limit of 63 columns and I would have needed 348.
I worked around this by dividing the number 348 by 63 and then constructing a
table in MS word with 5 rows containing approximately 63 columns each. Then,
I converted the table to text separated by commas (and deleted the spaces).
I was able to use the resulting list to pull data for a report using Business
Objects software.

Short story: All is well that ends well.

But, thank you very much for your kind attention and timely response -
(seriously)!

Sincerely,
DOUG
 
G

Gord Dibben

Excel 2007 has 16,384 columns so I don't see the problem.


Gord Dibben MS Excel MVP
 
D

DOUG

Gord: That must have been it, although I could swear I was working in 07 and
not 03 at the time.
Thanks,
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

Top