Download Excel File: https://ift.tt/2LMS71h
Download Text Files: https://ift.tt/2ypC4Oo
In this video we create a Material Supplier Report with All Suppliers Listed in Single Cell With Line Feed. We use a combination of Power Query Built-in featured like Group By and Merge Columns, and then we edit the M Code and use the Power Query Functions: Table.AddIndexColumn, Combiner.CombineTextByEachDelimiter, List.Transform, Text.From and Text.Combine. We also learn about a Line Feed in Power Query (Line Feed in M Code): #(lf) and how to use multiple delimiters in list syntax when merging or joining columns in Power Query.
Related Videos:
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