Create table using 2 tables and a third with multipliers

Hello!   I hope I can explain what im trying to attemp   I have 3 tables:   Table 1& Table 2 have the following structure   DATE | Name | Value (date)| ID 1  | Value 1   I have many ID's w...