How do I import sequential data into columns in Excel?

[Guest]

I have a raw text file containing a single list of data (tab separated) which
I want to import into columns. The data in question is temperature data taken
every hour over a full year to give 8760 values. I want to group this in
Excel by days, so I have 24 columns by 365 rows, with the first 24 values of
the data forming the first row, the next 24 the second and so on. Can anyone
suggest a way of doing this? I'm using Excel 2003.

 

[Frank Kabel]

Hi
if your data is on sheet1 in column A, enter the following formula in
cell A1 on a second sheet
=OFFSET('sheet1'!$A$1,COLUMN()-1+24*(ROW()-1),0)
and copy this formula accross.

afterwards select this data range, copy it and insert it with 'Edit -
Paste Special - Values' to remove the formulas

 

[Guest]

Excellent! Thanks for your help!

Hi
if your data is on sheet1 in column A, enter the following formula in
cell A1 on a second sheet
=OFFSET('sheet1'!$A$1,COLUMN()-1+24*(ROW()-1),0)
and copy this formula accross.

afterwards select this data range, copy it and insert it with 'Edit -
Paste Special - Values' to remove the formulas