Hi,
I need help
I have this table
| ID | Année | Logements |
| 20 | 2024 | 120 |
| 20 | 2025 | 210 |
| 20 | 2026 | 340 |
I would like to obtain this :
| ID | Année_2024 | Année_2025 | Année_2026 |
| 20 | 120 | 210 | 340 |
Thank you so much for your help!
Page 1 / 1
You could achieve this using lists. Here is an example how it can be done, assuming that you don’t have large number of years to cover.
(Apart from ID=20, I added another feature with ID=21 that is missing record for 2026)
This approach might be even better as you don’t have to list all key/value pairs.
(workspace with both options is attached)
Thank you so much hvukasinovic, it works perfectly.