Group up same values and provide total

[StuartO]

Hi

I have another query. I am trying to create a sheet which I can copy and paste into outlook that provides a component breakdown. To keep it simple for the people that it will be sent to I have concatanated values from a number of cells. At the moment if I have items that are the same the all come in as a seperate line due to the way the information has to be submitted. What I want to do is find a way of totalling all the seperate values together and return them on one line for each different type.

I am sure it can be done, but I am learning as I go and appear to have hit an excel wall!

I have attached a sample workbook, which will hopefully make it a bit clearer.

If anyone can help I'd be really grateful.