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)
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+18- 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)
+18- Contributor
This approach might be even better as you don’t have to list all key/value pairs.
(workspace with both options is attached)
