Zend certified PHP/Magento developer

Combine rows in Power Query based on a shared column value

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!