Collapsing rows of duplicate dates in a column leaving one row with a subtotal?
- by Will
I have several thousand rows of date, time, and values in columns.
Each row is contains a date, time for that date, and a value for that time period (hour)
So each 24 rows has the same date with each having the next hour of the day.
I'd like to collapse or group the 24 rows leaving the last row with a subtotal of the value (column D) to the right in column F.
While this can obviously be done manually, several years of data would take a while and there ought to be a way to do this other wise?