Forum Discussion
Solved
Transform Data : multiple columns -> one dimension
Hi, I have a table with different columns Person / Area 1 / Area2 / Area3 An example could be the following : Robert / France / UK / France Jane / Belgium / empty / empty In ord...
Hope this helps... All of these screen shots come from the Query Editor in Power BI
Your original data:
Select the 3 Area Columns and choose 'Unpivot Columns' from the Transform tab
Now under 'Add Column' - Add an Index Column (from either 0 or 1 depending on your neeeds.)
Here you go!
Hope this helps... All of these screen shots come from the Query Editor in Power BI
Your original data:
Select the 3 Area Columns and choose 'Unpivot Columns' from the Transform tab
Now under 'Add Column' - Add an Index Column (from either 0 or 1 depending on your neeeds.)
Here you go!
Thanks a lot for your answer.