Hi!

Do you mean that you want ALL the data in a SINGLE column?

1268*31 = 39,308

Assume the data is on Sheet1 A1:AE1268

In Sheet2 A1 enter this formula and copy down 39,308 rows:

=OFFSET(Sheet1!$A$1,INT((ROWS($A$1:A1)-1)/31),MOD(ROWS($A$1:A1)-1,31))

This may take some time to calculate!!!!

Once done inspect the results and make sure it did what you want. Then
select Sheet2 A1:A39308 and do a copy/paste special/values to convert the
formulas to constants.

You may have to do this in "chunks" as that's a fairly large range to copy
to the clipboard depending on your system resources.

Biff

"ratchick" wrote in message
...
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