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

excel
pivot_table

#1

Hi,

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


#2

@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.

Regards,
Sunil