Merge rows by column value depending on date filter

I have a single table from a query to an external source. Each row represents working hours done by a certain employee on a given date:   ID Employee Hours Date ------------------------------...