I'm new to alteryx and I'm trying to come up with a solution for gaps in multiple completions and expirations of the same individual among multiple rows.
| Name | ID | Completed Date | Expiration Date |
| A | 1 | 1/9/19 | 1/31/21 |
| A | 1 | 1/15/21 | 1/31/23 |
| A | 1 | 8/3/22 | 8/31/23 |
| A | 1 | 8/10/23 | 8/31/24 |
| B | 2 | 12/27/18 | 12/31/20 |
| B | 2 | 1/2/21 | 1/31/22 |
| B | 2 | 7/25/22 | 7/31/23 |
| B | 2 | 7/18/23 | 7/31/24 |
| C | 3 | 12/19/18 | 12/31/20 |
| C | 3 | 12/14/20 | 12/31/22 |
| C | 3 | 8/19/22 | 8/31/23 |
| C | 3 | 8/13/23 | 8/31/24 |
| D | 4 | 12/20/18 | 12/31/20 |
| D | 4 | 12/16/20 | 12/31/22 |
| D | 4 | 7/22/22 | 7/31/23 |
| D | 4 | 7/9/23 | 7/31/24 |
| | | This is how I want it to appear. |
| Name | ID | First Completed | Last Expiration |
| A | 1 | 1/9/2019 | 8/31/2023 |
| B | 2 | 12/27/2018 | 12/31/2020 |
| B | 2 | 1/2/2021 | 1/31/2022 |
| B | 2 | 7/25/2022 | 7/31/2024 |
| C | 3 | 12/19/2018 | 8/31/2024 |
| D | 4 | 12/20/2018 | 7/31/2024 |
