Return all values ​​appearing in a given column

Firstly, I duplicated the Table and named it Table2.

In Table, this is the M-Code to transform the column to the custom column that you want:

= Table.Group(Source, {"Produto"}, {{"Custom Column", each Text.Combine([Origem], ";"), type text}})

This is the result:

Then I use merge function in PQ to add custom column to Table2 to get the final result.

pls try again

let


lst = List.Buffer( Table.ToList( from,(x)=>x)),
f= (w)=>  Text.Combine( List.Transform(List.PositionOf( List.Transform(lst,(z)=>z{0}),w,Occurrence.All), (x)=> lst{x}{1}?),", "),
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUXJUitWBsJzALCO4mBGKmDOYZQyXNYbLmkDEYgE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Produto = _t, Origem = _t]),
    from = Table.TransformColumnTypes(Source,{{"Produto", Int64.Type}, {"Origem", type text}}),
    #"Added Custom1" = Table.AddColumn(from, "Custom", each f([Produto]))
in
    #"Added Custom1"