Hi - I have table as below.
| ID | End Date | 2021 | 2022 | 2023 | 2024 | 2025 |
| 1 | 12/31/2021 | 100 | | | | |
| 2 | 12/31/2023 | 100 | 200 | | | |
Here ID '1' has the End date of 12/31/2021 - so, we want to assume it has the end date of 2025 and add $100 to 2022, 2023, 2024,2025
and ID '2' has the end date of 2023 - so want to assume it has the end date of 2025 and add $150 (pick the last available amount) to 2024 and 2025.
The output will be as below.
| ID | End Date | 2021 | 2022 | 2023 | 2024 | 2025 |
| 1 | 12/31/2021 | 100 | 100 | 100 | 100 | 100 |
| 2 | 12/31/2023 | 100 | 200 | 150 | 150 | 150 |
Is this doable ?
