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

[mt599t]

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.

[Syndicate_Admin]

You seem to understand the subject really well.

[HotChilli · Accepted solution]

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

[mt599t]

Wow that was easy, Thank you!