Group rows in one column by another column.

[laganlee]

Hi

I want to convert this to two rows: 

So that it looks like this:

I've tried the usual 'group by' and pivoting, but I've got stuck!

I've also been experimenting with converting tables to lists and records..

Many thanks for looking.

[slorin · Accepted solution]

Hi,

Use Table.Group with Text.Combine

= Table.Group(PrevStep, {"ID"}, {{"Values", each Text.Combine([Values],","), type text}})

 Stéphane

[laganlee · Accepted solution]

Many thanks Stéphane! 

That is really much appreciated - that saved the day 😊

[slorin · Accepted solution]

Hi,

Use Table.Group with Text.Combine

= Table.Group(PrevStep, {"ID"}, {{"Values", each Text.Combine([Values],","), type text}})

 Stéphane