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

Do you have any merged cells?

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

In article ,
DOUG wrote:

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?

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

"JE McGimpsey" wrote:

Do you have any merged cells?

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

In article ,
DOUG wrote:

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?

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


Gord Dibben MS Excel MVP

On Fri, 30 Jan 2009 06:26:03 -0800, DOUG
wrote:

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

"JE McGimpsey" wrote:

Do you have any merged cells?

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

In article ,
DOUG wrote:

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?

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

"Gord Dibben" wrote:

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


Gord Dibben MS Excel MVP

On Fri, 30 Jan 2009 06:26:03 -0800, DOUG
wrote:

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

"JE McGimpsey" wrote:

Do you have any merged cells?

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

In article ,
DOUG wrote:

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?