I have a dataset with rows that have rows that need to be merged into a single one
| A | B | C | D | E |
|---|---|---|---|---|
| Title A | 34sfgert | 2020-04-05 | 2020-04-05 | 20 |
| Title A | 34sfgert | 2020-05-05 | 2020-05-05 | 20 |
| Title A | 34sfgert | 2020-06-05 | 2020-06-05 | 20 |
| Title B | 34sfgert | 2020-15-05 | 2020-15-05 | 12 |
| Title B | 34sfgert | 2020-16-05 | 2020-16-05 | 12 |
Column A is the title, column B is a person id, column B is the booked starting date, column C is the booked end date and the last column are the total hours booked per person.
The end result should look something like this:
| A | B | C | D | E |
|---|---|---|---|---|
| Title A | 34sfgert | 2020-04-05 | 2020-06-05 | 20 |
| Title B | 34sfgert | 2020-15-05 | 2020-16-05 | 12 |
Where the column B contains the value of the first row and column C has the value of the last row. The columns A and D remain unchanged.
