Transpose Appears to be Broken

[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

 

[JE McGimpsey]

Do you have any merged cells?

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

 

[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

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[DOUG]

Gord: That must have been it, although I could swear I was working in 07 and
not 03 at the time.
Thanks,
DOUG