G
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.
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.