By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,117 Members | 2,178 Online
Bytes IT Community
+ Ask a Question
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
Share this Question
Share on Google+
1 Reply


hyperpau
Expert 100+
P: 184
Hihglight at least two rows up to the last column then drag the lower right end of the corner down.
Aug 18 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.