I have multiple tables with overlap in the column headings. They share customer name, customer ID, amount, and location but also have other columns that are not shared. I am trying to create a pivot table that will use the customer name as the row, the location as the column, and then a sum of the amount from all of the tables involved. As I try to add values from the different tables into the values box of the pivot table it is duplicating the column. Is what I seek possible?