Virtual Table

I need a help creating a virtual table where Table 1 and Table 2 have same column names.

I want the certain columns to add up the values, meanwhile the remaining column to remain same. Sample tables shared below. Third table is expected final table.