Offset/Pivot

Hi everybody,

I have a table like this:

| ID | Name | From Date | To Date |
| 1  | PLAN | 2024      | 2026    |

and I want to change it to this :

| ID | Name | year |
| 1  | PLAN | 2024 |
| 1  | PLAN | 2025 |
| 1  | PLAN | 2026 |

any suggestion?

thanks in advance