Reformat and combine data Across Dates:vendor output in xls

[yunesm]

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.

Please Login or Register  to view this content.

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!