Tuna123,
In Excel, how do you establish relationship between the two tables you post? And what table do you create additionally in Excel? Please help to elaborate more details and post expected result in table based on the above sample tables.
Regards,