Hi everyone,
I have an example of the data I'm working on:
| ID | Date | Is student? |
| 1 | 01/01/2022 | Yes |
| 1 | 01/01/2023 | Yes |
| 1 | 01/01/2024 | Yes |
| 1 | 01/01/2025 | No |
| 2 | 01/01/2024 | Yes |
| 2 | 01/01/2025 | Yes |
| 3 | 01/01/2025 | No |
| 4 | 01/01/2025 | No |
I want to create a workflow, that give me an output like below:
| ID | Yes | No |
| 1 | 01/01/2022 | |
| 1 | 01/01/2023 | |
| 1 | 01/01/2024 | |
| 1 | | 01/01/2025 |
| 2 | 01/01/2024 | |
| 2 | 01/01/2025 | |
| 3 | | 01/01/2025 |
| 4 | | 01/01/2025 |
I would appreciate your support.
Thanks
