Transform Data : multiple columns -> one dimension

[anthony44]

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 order to analyze the survey with area dimension, I have to transform the initial table to :

Index / Person / Area

with my example,

0 / Robert / France

1 / Robert / UK

2 / Robert / France

3 / Jane / Belgium

Index could be important to be sure that I can observe two answers from Robert where area is France.

I hope that someone will be able to help me to realize this transformation to obtain this result.

[fhill · Accepted solution]

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!

[anthony44]

Thanks a lot for your answer.