Aggregate multiple rows into a single row, separating values by semicolon

Hi valcat27 ,

Try this:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTI0ABFKsTpIXBNULpAA8Y2ATEsgNkLhWYJ5xkCWORjHxgIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [SalesID = _t, ClientID_max = _t, ClientID_all = _t]),
    #"Added Custom" = Table.Group(Source,{"SalesID","ClientID_max"},  {{"Column", each Text.Combine([ClientID_all],  ","), type text}})
in
    #"Added Custom"

Reference:

Power Query - Combine rows into a single cell - Excel Off The Grid

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.