Pivot table, sum value next column

Hi all,

For the company I work for, I regularly come across the table format below. This format is hard to work with, I have manually changed the format a couple of times but I'm getting more and more questions were I need to check these tables.
These Excel sheets are updated from a database via an sql connection in Excel.

In these tables every row is a production order, then there are multiple columns which first state the compound that has been added and then the amount. On a row a compound can be added multiple times, a single production can be split into multiple rows but these are not always below each other.

For example:

production	Compound1	Weight1	Compound2	Weight2	Compound3	Weight3
aa	A	100	B	30
bb	B	60	B	60	C	10
aa	A	10	B	3
cc	C	50			A	50

It would really help if Excel could add up the same production to the same row and add up if 1 compound is added in steps, resulting in:

	A	B	C
aa	110	33	0
bb	0	120	10
cc	50	0	50

This looks to me similar to a pivot table, but I would need a sum of values in the next column. So sort the first table on column B, D and F but show the sum of column C, E, and G.
Does someone know how to do this in a pivot table? If not, do you know a easy way to this in another way?

Looking forward to your reply's
Daniel