Use the power query functions in excel to build connections to your two tables. Then you can build relationships at will and combine and display using any pivot process you want. Upload an example of the data and I will provide with an example.