Array Formula – List All Suppliers by Material in Single Cell with Line Feed, Excel Magic Trick 1579

Download Excel File: https://ift.tt/2LMS71h
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

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.