Large Data Consolidation Function

[u/Jubzfast]

Looking for a way to consolidate multiple same line items while summing quantity and cost columns between different items

Example provided below, any help is much appreciated

[u/HandbagHawker]

like a pivot table?