Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I need to change a column to delimited rows grouped by another column.
It's easier to say it by a picture! :
Many thanks for looking!
Solved! Go to Solution.
Hi,
Select column B, then Group By
Replace the part : each Text.Combine([A], ",")
Here is the code:
= Table.Group(#"Changed Type", {"B"}, {{"A", each Text.Combine([A], ","), type nullable text}})
Hi,
Select column B, then Group By
Replace the part : each Text.Combine([A], ",")
Here is the code:
= Table.Group(#"Changed Type", {"B"}, {{"A", each Text.Combine([A], ","), type nullable text}})
Hi Olga,
That's fantastic!
That's saved the day 😊
Many thanks