How to create Pivot table from two or more sheets in excel?




I have raw data available in two sheets of excel. I want to create a pivot table from data available in both sheets. Please help me.

Thx, Mukesh


You can create pivot table from multiple sheets using consolidation feature.

You can select consolidation option from pivot wizard in step 1 only. Select multiple consolidation ranges Then next and next after that you can provide data ranges and add them. After that Click on next and finish. Here we have pivot table from all the data sheets.