Combine rows of a table

[Moniek]

Hi, I have got table 1 and I want make Table 2. Does anyone knows how to do?

Thankx!

[Moniek · Accepted solution]

Thankx Stéphane for the code, does I add a custom column? Or where Can I add the code, in M?

[slorin · Accepted solution]

No, just add a new step and replace "Your_Source" by your "previous step"

[Moniek]

Thanks, I haven already solved it. 

[slorin]

Hi,

Table.Group(
   Your_Source,
   {"Column 1"},
   {  {"Column 2", each Text.Combine([Column 2], " / ")},
      {"Column 3", each List.Sum([Column 3])}},
   GroupKind.Local,
   (x,y) => Byte.From(y[Column 1] <> null))

Stéphane

[Moniek · Accepted solution]

Thankx Stéphane for the code, does I add a custom column? Or where Can I add the code, in M?