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!
Solved
Create column from row values and transpose Attribute values
+2- Contributor
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)
+13- Contributor
- Best Answer
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)
+13- Contributor
This approach might be even better as you don’t have to list all key/value pairs.
(workspace with both options is attached)
1 person upvoted this
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.