This macro solution uses 3 separate macros all called from the first.
first:
creates a temporary sheet
distributes the data to columns
second:
creates lists of unique dates and hours
third:
a loop within a loop filters by date and hour
numbers extracted and written to separate sheet
deletes the temp sheet when finished
Your sample data of 28,707 records requires 624 filters being applied and removed.
Results in 501 lines being written to the sheet.
Takes an eternity to run (43 seconds on my computer).
Sorry, I'm not sharp enough to speed that up.
Zipped due to file being just over 500 KB.
|