Excel Magic Trick 1252

DESCRIPTION

Power Query To Create Unique List of Invoice Numbers with Balances
From An Excel Table that stores Invoice data with line item data for invoices (duplicate invoice numbers in the Invoice Field (Column), learn how to use Power Query to create a Unique List of Invoice Numbers with Balances. See that the output from Power Query is dynamic and so updating the list when new invoices is dynamic.

WORKBOOKS