Data Formula Help

Hi,

I'm trying to consolidate data and need a bit of help to get it to do what i need. 

I'm looking to consolidate a table of data which has item names and costs. 

I want to merge the names together that match across the table and add the individual costs to create a total. 

For example see below:

So I need the part name, description, cost ea, markup etc merged (if they match) - but them the qty and price total added. 

Can anyone help?

Thanks in advance.