Consolidating Rows

**brcaston** · 06-24-2010, 01:01 PM

I am sure this is an easy one, but I am at my wit's end trying to make work. Attached is some sample data, and what I am trying to do is consolidate information from 15 minute periods to 30 minute periods with a formula that can be used of the span of 24 hours. For example:

06/17/10 0600 2
06/17/10 0615 9
06/17/10 0630 16
06/17/10 0645 20

Consolidate the data so that it will read:

06/17/10 0600 11
06/17/10 0600 36

Any help is appreciated.

Thanks

**zbor** · 06-24-2010, 01:16 PM

Something like this:

**brcaston** · 06-24-2010, 01:24 PM

Yes, but is there a way to place it into another spreadsheet wihout using a pivot table? If not this get s me on the right track.

Thanks

**shg** · 06-24-2010, 01:25 PM

Rename the sheet Sheet1 (so I don't have to do so much typing)

Insert a new sheet, Sheet2.

In Sheet2

B1: =Sheet1!B3
C1: =Sheet1!C3
D1: =SUM(Sheet1!D3:D4) and copy across

Copy the formatting from row 3 on Sheet1 to row 1 on Sheet2

On Sheet2, select rows 1 AND 2, and drag down the fill handle as far as necessary, which copies formulas to alternate rows.

Sort Sheet2 by Col A then col B.