Reformat and combine data Across Dates:vendor output in xls

Reformat and combine data Across Dates

Hello,
I have an interesting challenge.

I have a vendor output in xls that is counting the number of units per day per hour.

The output should have all of this data on one row per day. However, the data is currently be exported so that hour has it's own row.

The vendor has been identified of the error but the problem will not be addressed for a couple of weeks. We will have dozens of these spreadsheets per day this week that need to be processed but I need help with a fast way to reformat the spreadsheet.

I was going to use this code to fill in the data and filter out the duplicate dates per row but the blanks in the first date will not let this work.

Sub fill_and_filter()
Dim oRng As Range
    Set oRng = Selection
        
        Selection.SpecialCells(xlCellTypeBlanks).Select
        Selection.FormulaR1C1 = "=R[-1]C"
    oRng.Copy
    oRng.PasteSpecial Paste:=xlValues, SkipBlanks:=False

End Sub

I've attached two spreadsheets: the output and what I'm trying to do.

The columns of the spreadsheet are fixed but the rows will vary from file to file.

Please let me know your thoughts.

Any help will be very much appreciated.

Thanks!