Forum Discussion
laganlee
Helper II
2 years agoChange a column to delimited rows grouped by another column.
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!
- 2 years ago
Hi,
Select column B, then Group ByReplace the part : each Text.Combine([A], ",")
Here is the code:
= Table.Group(#"Changed Type", {"B"}, {{"A", each Text.Combine([A], ","), type nullable text}})
- 2 years ago
Hi Olga,
That's fantastic!
That's saved the day 😊
Many thanks
olgad
Resident Rockstar
2 years agoHi,
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}})
laganlee
Helper II
2 years agoHi Olga,
That's fantastic!
That's saved the day 😊
Many thanks