Find all the rows's value that matching one value in current row (Power Query)

[Michael_Tsai]

Hi here is my data:

How do I combine the retailer information in each row that have the same phone model in Power Query without group by?

Here are some examples that i expect the outcome

Thanks in advance!

[AlienSx · Accepted solution]

Hi @Michael_Tsai 

let
    Source = your_table,
    groups = 
        Table.Group(
            Source, "Phone model", 
            {{"all", (x) => Table.AddColumn(x, "Used_Retailer", (w) => Text.Combine(x[Retailer], ", "))}, 
            {"Exclusive_Retailer", each if Table.RowCount(Table.Distinct(_)) = 1 then "Y" else "N"}}
        ),
    expand = Table.ExpandTableColumn(groups, "all", {"Retailer", "Used_Retailer"}, {"Retailer", "Used_Retailer"})
in
    expand