I have several sets of data organized into tables. Each table contains the same headings. The tables contain detail about projects related to facilities, and I need to use a pivot table to summarize the data. I need to end up with a pivot table where the rows are building names and the columns are years, and the values are sums of all of the projects for that building in that year. I've used the pivot table wizard and the multiple consolidation ranges, but I don't end up with the columns in my original tables as choices for my pivot table.