Transform Data from rows to columns

[Anonymous]

Hi, 

is it possible to transfrom some table from these structure:
ID          Attribute

4711      A

4711      B

4712      A

in the following result:
ID       Attribute
4711   A|B
4712   A

Thanks for youre help!

[SundarRaj]

Hi @Anonymous , here's a quick solution to this transformation. Thanks

[slorin · Accepted solution]

Hi @Anonymous 

Group by ID, choose Sum and replace List.Sum by Text.Combine(  , "|")

= Table.Group(Source, {"ID"}, {{"Attribute", each Text.Combine([Attribute], "|"), type text}})

Stéphane