Extracting specific data from columns and returning in one row

Hi,

Reposting as my old title was rejected

I work in purchasing and once a week I export a report from SAP into Excel to produce an out of stock report.

The report pulls through all products with nil stock but repeats the product on a new row for each purchase order yet to arrive. This could be one row if only one order due to arrive or several rows if ordered regularly.

I want to show just one row for each item and in that row show 4 columns with the next two due dates and quantities due

Is there a way to filter this list to just return this?

Crude example below of the initial report

Product Stock Qty due. Date due

Product A. 0. 50. 5/6/26

Product A. 0. 75. 10/6/26

Product A. 0. 20. 15/6/26

Product A. 0. 70. 20/6/26

Product B. 0 10. 3/6/36

Product C. -5. 20. 4/6/26

Product C. -5. 40. 30/7/26

Product D. -8. 100. 15/6/26

Product D. -8. 50. 30/6/26

Product D. -8. 75. 20/7/26

Product D -8. 20. 30/7/27

Final report required

Product. Stock qty due date due qty due date due

Product A. 0. 50 5/6/26. 75 10/6/26

Product B. 0. 10. 3/6/26

Product C. -5. 20. 4/6/26. 40. 30/7/26

Product D. -8. 100. 15/6/26 50. 30/6/27

This is all currently done manually but I'm thinking there must be a smarter way of doing it.

Thankyou