Pivot chart to pull data from two tables

[SamHorlick]

Hi,

I've been looking for hours on how to do something that I thought would be extremely simple.

I have two tables with two columns: Location and Weight.

Table one contains locations: A, B, and C-and a corresponding weight for each location
Table two contains locations: C, D, and E-and a corresponding weight for each location

I want to simply combine these into one pivot table that show locations A, B, C, D, and E along with their associated weight. (Location C should show the sum from both tables).Notice how table 2 mostly has different locations from table 1 so I don't think I need to connect the data, I just want to have a table that sums the two up basically.

Thanks,
Sam

 

[jondavis1987]

From my experience, a pivot table can only pull data from one table. I've had to set up vbas to combine tables into one table for this