Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to transpose values with Power Query in a column using a separator

Hi everyone,

 

I hope some could help us to make the following transformation

 

We have a file that has a column called "role", but some of these roles ar concatenated in a single column and they are separated by a "/". 

 

 

We need to create a transformation in PowerQuery (or DAX) that creates the following output:

 

 

Basically we need to count de number of separators and create rows bellow the current row and then transpose the roles and drag all other columns until the next one and so on.

 

Does anyone knows how to archive this?  This would really help us Thank you.

 

  • Split the column by delimiter (using /) and there's an extra option under Advanced which is Split into Rows

3 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion

    Split the column by delimiter (using /) and there's an extra option under Advanced which is Split into Rows

    • Anonymous's avatar
      Anonymous
      Not applicable

      Wow that was easy, Thank you!