Forum Discussion

anthony44's avatar
anthony44
New Member
9 years ago
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 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's avatar
    fhill
    9 years ago

    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!

2 Replies

  • fhill's avatar
    fhill
    Resident Rockstar
    9 years ago

    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!