Forum Discussion
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
- HotChilliCommunity Champion
Split the column by delimiter (using /) and there's an extra option under Advanced which is Split into Rows
- AnonymousNot applicable
Wow that was easy, Thank you!
- Syndicate_AdminAdministrator
You seem to understand the subject really well.