Hello I have a database as:
I would like to reformat the table so that for each ID there is only row with the start date and end date that ID has been in each division:
Do you have any idea on how to do this?
Thank you so much in advance.
ID | Start date | End date | Division |
100 | 15/01/96 | 17/03/09 | 1 |
100 | 18/03/09 | 22/05/11 | 1 |
100 | 25/05/11 | 2/05/18 | 2 |
100 | 3/05/18 | 7/06/20 | 2 |
100 | 7/06/20 | 20/12/20 | 1 |
101 | ... | ... | ... |
I would like to reformat the table so that for each ID there is only row with the start date and end date that ID has been in each division:
ID | Start date | End date | Division |
100 | 15/01/96 | 22/05/11 | 1 |
100 | 25/05/11 | 7/06/20 | 2 |
100 | 7/06/20 | 20/12/20 | 1 |
101 | ... | ... | ... |
Do you have any idea on how to do this?
Thank you so much in advance.