Sorting Products to Raw materials and add the weight and the week produced

Hello Experts!

I got a problem to solve and it is out of my expertise to do that. Thanks to everyone trying to help me with it!!

PLEASE SEE THE SAMPLE FILE ATTACHED!!



I have a file with two tables. One holds all the Raw material and in what Product it is used, when and with what weight.

Now I need to fill table 2 with the weight data for every week of the year per Rawmaterial and Product.



Raw material 1 / Product 1 Week1 weight / Week 2 Weight / Week 3 Weight and so on.....
/ Product 2 Week1 weight / Week 2 Weight / Week 3 Weight and so on.....
/ Product 3 .... Week1 weight / Week 2 Weight / Week 3 Weight and so on.....

Raw material 1 / Product 1 Week1 weight / Week 2 Weight / Week 3 Weight and so on.....
/ Product 2 Week1 weight / Week 2 Weight / Week 3 Weight and so on.....
/ Product 3 .... Week1 weight / Week 2 Weight / Week 3 Weight and so on.....

I hope I made myself clear, but I guess you get the idea in the sample file.

Thank you very much in advance!!


JP