Excel/Access - How to combine rows of data?

[bcr123]

Hello.

Could you please help with following problem in Microsoft Excel:

I have thousands or rows of 5min data that I need to convert to 15min and later to 20min data do some calculations.

Data looks as following (4 rows out of thousands):

A B C D E F G
3/17/2008 9:55:00 1995 1995 1995 1995 2
3/17/2008 10:00:00 1995 1995 1995 1995 1
3/17/2008 10:05:00 1995 1995 1995 1995 1
3/17/2008 10:10:00 1992 1992 1992 1992 1

My problem is that I don't know how from preceding four rows to make one row as per following criteria and than keep on doing the same with the rest of rows:

- have dates flow in column A and be accurate to other columns
- =B1 (and than the same 4 rows later)
- =C1 (and than the same 4 rows later)
- =MAX(D1:D4) (and than the same 4 rows later)
- =MIN(E1:E4) (and than the same 4 rows later)
- =F4 (and than the same 4 rows later)
- =SUM(G1:G4) (and than the same 4 rows later)

Speedy reply and help would be greatly appreciated.

Thank you!

[hyperpau]

Hihglight at least two rows up to the last column then drag the lower right end of the corner down.