Download Excel File: https://ift.tt/2McTaa8
In this video learn how to take an invoice table, list the unique combinations of Invoice & Vendor and then list the items (references) horizontally. See the Old School Array Formula and the new Office 365 Dynamic Array Formulas. This formula takes a proper data set and does two things: 1) Lists the unique records, then 2) lists items horizontally from the reference column next to each extracted unique record.