Blog

How to consolidate multiple sheets into single sheet using Pivot Table

How to consolidate multiple sheets into single sheet using Pivot Table



                                                                       Many time we will get data from different sources in same format and we require to consolidate the same data in to single sheets and which will take more time to make data in single sheet and here we have a method in Pivot table  by consolidation method.

Step-1
We need to open the pivot table   by using the short cut Alt+D+P 


Step 2
 Click on the "I will create the page fields"


Step-3

Select the data range from the multiple sheets and click on Add button


Step 4

Click on the How many page fields  in second option "1"  and type the sheet name in field one tab


Step-5

Click on the next and click on the Finish


and Finally we get the pivot table report of the multiple sheets with consolidated data and we can able to apply the same more sheets also .






Video Link: Watch Video

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