Download Excel File: https://excelisfun.net/files/EMT1579-1580.xlsx
In this video we create a Material Supplier Report with All Suppliers Listed in Single Cell With Line Feed. First we joining three columns with Supplier Data, Then create a Running Count for each Material, then use the Office 365 Dynamic Array Functions UNIQUE & FILTER to create the report. Also see the Functions: COUNTIFS, TEXTJOIN, and CHAR.

Related Videos:
Power Query – List All Suppliers by Material in Single Cell with Line Feed, Excel Magic Trick 1580
Count, Join then Lookup Suppliers & List in Single Cell With Line Feed, Excel Magic Trick 1579
Unique Invoice / Vendor List with Items Listed Horizontally - Excel Dynamic Array Formula- EMT 1575
Power Query M Code Group By Formula to Transform Invoice Table - Excel Magic Trick 1576