Combine multiple rows into one row within the same day

Hi, I have a table generated from SQL that looks like this  ts_start ts_end unit Number reason 1/11/2021 0:00 1/11/2021 10:42 X100 5000   1/11/2021 10:42 2/11/2021 0:00 X100 0 ...