Consolidate a packing list with Formulas or Macros possible?

[HAK88]

I would like to know if it is possible to consolidate a packing list by comparing the Purchase Orders and Item Codes.
If the Purchase Orders match each other AND the Item Codes are the same, then add the Lengths together, removing the unnecessary lines.
I am not sure how to get the Batches to combine as well.
I suspect what I want to do might not be possible unless done manually.
Example of the Packing list AND what I would like to achieve below.
Any Formulas, Macros or ideas are welcome.
Example:

Before
Item Code	Description	Batches	Lengths	Unit	Purchase Order
50102​	Green	1 x 100	100​	M	11a
50102​	Green	1 x 100	100​	M	11a
50102​	Green	1 x 100	100​	M	11a
50102​	Green	1 x 100	100​	M	12b
50102​	Green	1 x 100	100​	M	12b
60105​	Blue	1 x 100	100​	M	11a
After
Item Code	Description	Batches	Lengths	Unit	Purchase Order
50102​	Green	3 x 100	300​	M	11a
50102​	Green	2 x 100	200​	M	12b
60105​	Blue	1 x 100	100​	M	11a

 

[HAK88]

Not sure where the Edit button is located.
The Items code also contains Letters, Example : RAP-50102