440,117 Members | 2,178 Online
Need help? Post your question and get tips & solutions from a community of 440,117 IT Pros & Developers. It's quick & easy.

# Excel/Access - How to combine rows of data?

 P: 47 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! Jul 17 '08 #1