I have an export from quickbooks showing all outstanding invoices. Each invoice consists of only 2 line items: “Consulting Fee” and “Admin Fee”. The QB export creates a row for each of the line items. They share a common column datapoint of “Invoice”.
The data requires a lot of massaging so I’m doing that in Power Query.
How could I get the rows “merged” into single rows based on Invoice #, preferably within Power Query?
Thanks!