I have a result in Excel that consists of customer's invoices and payments. The data are on a separate row for every invoice and payment which looks like this:
I would like the invoice and payment to be combined in a single row and the outstanding indicating as 0 value. Below is my intended results (highlighted in bold):
You can download the spreadsheet here:
Can anyone help provide me with the required solution?