Download Excel File: https://ift.tt/32WVp7l
In this video learn how to take an invoice table, list the unique combinations of Invoice & Vendor and then list the items (references) horizontally. Learn how to use Power Query to create a solution. Learn how to edit the M Code in the Power Query Solution. Learn about the M Code Power Query Functions: List.Distinct, List.Transfrom, Table.Group and Text.Combine.
Related Video: Unique Invoice / Vendor List with Items Listed Horizontally – Excel Dynamic Array Formula- EMT 1575