Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose Feature Inop
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose Feature Inop
Are some of these cells merged cells? That's what the error sounds like.
HTH Otto "DOUG ECKERT" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose Feature Inop
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 "Otto Moehrbach" wrote: Are some of these cells merged cells? That's what the error sounds like. HTH Otto "DOUG ECKERT" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transpose Row by Row | Excel Worksheet Functions | |||
I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions | |||
Yes / No Feature | Excel Worksheet Functions | |||
Transpose | Excel Worksheet Functions | |||
TRANSPOSE() | Excel Worksheet Functions |