Transpose Appears to be Broken
 

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

Transpose Appears to be Broken
 

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?

Transpose Appears to be Broken
 

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?

Transpose Appears to be Broken
 

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?

Transpose Appears to be Broken
 

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?