Create a list that contains duplicates and unique names and no blanks

1 Select the whole table, till last row.
2 Remove the duplicates Data
Remove Duplicates
Check customer, ID, REG Hours, Dates
OK
3 Sort Data
Sort
Date, ID
OK

4 Result

Copy the table to other range and try it.