Change a column to delimited rows grouped by another column.

[laganlee]

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!

[olgad · Accepted 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}})

[olgad · Accepted 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}})

[laganlee · Accepted solution]

Hi Olga,

That's fantastic! 

That's saved the day 😊

Many thanks