Get instant live expert help on I need help with two-way table

using a two way chart to create a data table

I have two tables with the following columns: a) Table 1 with following columns: No, Country, State, Site, Site Category, Shift b) Table 2 with following columns: Site, Vertical I want to create a pivot table with these two tables. I want to link the sites from Table 1 with verticals from table2. The columns in the two table are not the same. The two tables are present in two different worksheets I want to know a feasible way of linking these two tables using Pivot tables. It would be really helpful if you could provide a step by step process for the same. Looking forward for your response Thanks!

I would like to create a third table where the calculated values are a result of dividing data in pivot table 1 by data in pivot table 2. I want to do it this way so when I move rows around in the first two tables and the first two tables adjust, I would like the third table to adjust in similar fashion so I don't have to deal with manual adjustments.

I have three tables on three different worksheets. One table is an input table where the data is entered, and the other two tables use the data from the input table to make calculations. Is there a way to get the calculation tables to autoexpand when a new line of data is entered into the input table without using VBA?

How do you combine two pivot table columns?