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!
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!
Best answer by hvukasinovic
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)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.