I have tried to do the 'multiple consolidation ranges' option when doing a pivot table but I can't get it to work.
Please do as follows to combine multiple worksheets’ data into a pivot table. Like if I just pasted these datatables in a sequence. Combine multiple sheets into a pivot table. Excel Tab is one of the lowest efficient way to split and manage data. What I am looking to do is just to create a big pivot table containing and consolidating all of this data as if there was just one worksheet (I need to have them in multiple worksheets). Before you split the pivot table, You can right click on the pivot table, Pivot table option -> Data Tab -> Retain Items deleted from the data source -> Change the option to None Though, I dont agree with the website Jon’s idea to split the pivot table in tabs. You can see my data fields from my three sheets below: They all summarize possible savings divided onto different savings types (Savings type 1-6) and distributed over a certain amount of years. The savings initiatives connected to each area have names (such as HR.1, Fin.7). My data is a bunch of savings initiatives that are distributed over a certain amount of areas within the organization (such as HR and Finance). I am trying to consolidate data with the exact same columns, from multiple worksheets (or ranges) into a pivot table.
