how can i transform this:
| Person | Role start date | Role end date | Effective date | Effective end date | Pay |
| 1 | 2014-12-01 | 2021-01-29 | 2017-07-01 | 2020-06-30 | 30 |
| 1 | 2014-12-01 | 2021-01-29 | 2020-07-01 | 2021-01-01 | 31 |
| 1 | 2014-12-01 | 2021-01-29 | 2021-01-02 | 2021-01-07 | 32 |
into this:
| Person | Start | End | Pay |
| 1 | 2014-12-01 | 2020-06-30 | 30 |
| 1 | 2020-07-01 | 2021-01-01 | 31 |
| 1 | 2021-01-02 | 2021-01-29 | 32 |
the [Start] will always be [Role start date], and the [End] will always be [Role end date] but I want to incorporate the effective dates in as well.
