Add rows to table according to grouping in different table

Hi,   I would like to add rows to one table ( or combine two tables) according to group number from another table.   These are what I have: Table 1 Name Part A x1 B y1 B x1 ...