Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a worksheet with 1268 rows and 31 columns. Ideally I need all the
rows to be converted to one column, although I believe this is impossible without some additional manual steps. Every time I attempt to copy/transpose my rows to columns, I receive the message that the paste area does not match the size of the copy area. I have tried transposing a few rows at a time. I have tried transposing ONE row at a time. Each time I try, I either receive an error message, or get the #VALUE! error message in the cell. I've tried TRANSPOSE and MINVERSE. I would prefer NOT to do this manually as I have about 30 worksheets of a similar size, and I'd really like to have my thesis done in five months...sooo...if anyone has any ideas for me, they would be much appreciated. As well, if Excel cannot handle an action of this size, does anyone know any other programs that might?? Thanks, Suzanne |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Search a worksheet, extract rows using a list from another sheet | Excel Discussion (Misc queries) | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
What is fastest for this? The Small VBA or many Worksheet Functions...? | Excel Worksheet Functions | |||
Converting rows to columns on a large scale | Excel Discussion (Misc queries) | |||
Incrementing rows (or columns) to a reference in another worksheet | Excel Worksheet Functions |