Blog

How to Consolidate Multiple range of Data using Pivot Table

How to Consolidate Multiple range of Data using Pivot Table

  


                   Pivot Table may be usually used in your Excel’s daily use, but many of the users are not used the pivot table option for the consolidation of the data, which can easily be done without using any complicated formula and we can do consolidation of the data in Multiple Workbook and Multiple Sheets.
Unfortunately, this option of the Pivot Table cannot be view on the screen, and we need to select the option from the quick access bar or using Short Key ALT+D+P.


Step-1
How to enable the Pivot Table and Pivot Chart wizard option ?


And here we need to consolidate the data from the three different workbooks named Jan, Feb, and March using this pivot table.
Step-2
Consolidation of the Multiple Workbooks using Pivot Table

Select the range and click add option.

Step-3
Click on the option of page field option 1 and name the range field name which we can able to view the final report.
O



 Consolidation the Multiple Sheets using Pivot Table and Name Manager Option
             We can use another easy method for the consolidation of the multiple sheets in the excel using a tricky method by naming the range in the name box .





Step-2

Name Manager option helps us to insert the range in the pivot table option by pressing the F3 key which will pop up the message of the name option and just we need to click the name for adding the range in the pivot table.





Step-3

Click on the option of page field option 1 and name the range field name which we can able to view the final report.




And this report is dynamic and if change any values in the data range that will reflect dynamically by just refreshing the data by clicking refreshing all in the data tab.


Video Link: Watch Video

Phone : +91 8606648045
Email : info@excelskillcorner.com
Excel Skill Corner
Kerala, India.