Grouping rows by like values and combining subsequent columns

[zraptor]

Hello!  I have a problem that I am sure is probably pretty basic but my brain has quit functioning and I can't get past this.  I have a table with two columns.  An ID column and a Service column.  Shown below:

ID	Service
65895976	10
86019440	12
86019440	10
65895976	20
65895976	30
86019440	12
65895976	10
87335274	20
30595323	20
84777902	10
84777902	30
84777902	50
45320398	10
65895976	10
88852113	20

As you can see, the ID column has duplicate values, I would like to combine the duplicates in the ID column and then concatenate the Service column for each row as shown below:

ID	Service
65895976	10,20,30,10
86019440	12,10
87335274	20
30595323	20
84777902	10,30,50
45320398	10
88852113	20

ANy help would be GREATLY aooreciated!!!

[Ashish_Mathur · Accepted solution]

Hi,

This M code works

let
    Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Service", type text}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"ID"}, {{"All services", each Text.Combine([Service], ", ")}})
in
    #"Grouped Rows"

Hope this helps.

[zraptor]

Perfect!  Thank you so much!

[Ashish_Mathur]

You are welcome.