Hi!

I'll give it a go and let you know if it worked out.

Oh, it'll work! Just do it in "chunks".

Wherever there are empty cells, the formula will return 0.

Biff

"ratchick" wrote in message
...
Hi Biff,

I'll give it a go and let you know if it worked out. This is daily
temperature data for over a century I'm looking at (which is why there's
so
much of it). So that brings the problem of not every row containing the
same
amount of columns.

In any case, thanks for the suggestion...I'll try it in the morning...

Regards,
Suzanne

"Biff" wrote:

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