FIFO help

Please see attachment

I need to correlate the GRN No & Vendor Code against each issues, so that I know against which receipt, a particular issue has been made.(it it involves 2 different GRN/Vendor then both should show up)

I also need the formula, since I have this issue on a regular basis.

The data is not complete hence there may be errors (in the sense that there may not be receipts but issues would show up-- but pl ignore such issues)

Thanks for the help in advance.

Regards and Have a great day.