• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table from multiple sheets

C

chssundeep

Member
Hi Friends,

Please guide me how to create a Pivot table from multiple sheets...

Attached the sample excel sheet
 

Attachments

  • sample.xlsx
    10.8 KB · Views: 7
Add the Pivot table wizard to your QAT
Start the PT Wizard
upload_2016-4-29_21-55-1.png
Use the above settings,
Next

upload_2016-4-29_21-55-52.png
Create a Single Page Field for Me
Next

Select Each page in Turn
Select the whole data range Including Headings

upload_2016-4-29_21-57-26.png
Add the Range and repeat on the next worksheet
Next

upload_2016-4-29_21-58-29.png
Select Either option above
Finish

You now have the whole 24 Records on a single worksheet
upload_2016-4-29_21-59-36.png

Enjoy!

It is worth noting that the order of the fields or Blank Columns doesn't upset the PT Wizard.
It is critical that common Fields have Common Field Names of the PT Wizard will add them as different fields
 
You must log in or register to reply here.
Back
Top