Analyze the data in two tables

Visitor

Hi, I have the following two tables. (Production forecast and Material Consumption)

Production Forecast 

ProductJulyAugustSeptember
A100110105
B150160140
C170150120
B140130

120

 

Material Consumption for 1 nos product (Material - X, Y, Z)

ProductXYZ
A11-  
B11
C111
B-  11

 

Do we have an easy way to get the month-wise material requirement like the following table?

MaterialJulyAugustSeptember
X ?  ?  ? 
Y ?  ?  ? 
Z ?  ?  ? 

 

 

 

 

 

 

 

 

 

0 Replies