Concatenate results in one CELL for for each item

[DanFromMontreal]

Dear Power Query community,

I would like to obtain a table containg, for each individual Source, all the Type-Num in 1 cell.

Left side is what I get when I analyze ma data via a Pivot Table.  Not exactly what I want.

Is there an easy way with Power Query to transform the data and get what I want?

Thank you

[Vera_33 · Accepted solution]

Hi @DanFromMontreal 

You can group by in Power Query, your original dataset can do Concat in DAX and show the result in visual as well

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtQ1NPY3M4xS0lFycvaN0DU0NzYwV4rVwZQxBspgSgRE6JoYGlogSVgEwnVYWpoqxcYCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Source = _t, #"Type-Num" = _t]),
    #"Grouped Rows" = Table.Group(Source, {"Source"}, {{"Type-Num", each Text.Combine(_[#"Type-Num"],";")}})
in
    #"Grouped Rows"

[DanFromMontreal]

@Vera_33 .  Just what I needed and simple.  Thank you