Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1575.xlsx
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.