How do I join two tables in Excel?

I have Table 1 and Table 2. How do I use formulas/pivot table to match Product Category and Product Name between Table 1 and Table 2, and come up Table 3?   Table 1 Warehouse         Product Categ...