How to Create a PivotTable From MULTPLE SHEETS in Excel (Different Headers or With the Same Headers)

[@kellyboth5060]

THANK YOU. No one else has done it this simply. Thank you so much!!!

[@IvanCortinas_ES]

Another great tutorial. Thank you for your explanation Chester!

[@wayneedmondson1065]

Thanks Chester. Great video! Always good to practice Pivot Tables and Power Query transformations :)) Thumbs up!!

[@katyaimai]

Just what I need. Thank you so much

[@ChesterTugwell]

Glad it helped!

[@NatalieDunn0502]

Amazing! Thank you!!

[@maddiekarcher2481]

When I create a pivot table mine doesn't show the option to "add to the data model". I'm in app and updated as well? Is there something I need to select beforehand

[@MarissieV]

As easy how it may look in your video, it doesn't work with me. It keeps saying "Both selected columns contain duplicate values. At least one of the columns selected must contain only unique values to create relationship between the tables". That I have but even when I choose these columns to match, it won't let me press OK and keeps saying the same. Is there something I am doing wrong here or missing?

[@emmayang880]

Very useful!

[@tariqhamadi4009]

Thank u 4 this boss Can I ask if the data share between the tables is not unique mean I have double data in one of that tables Is it work normal? Thanks again.

[@sunny1431993]

Hi how can i calculate a duration of specific two dates between two different days. Ex i want duration of 03-Mar-21 and 25-Mar-21 from 10-Mar-21 to 30-Mar-21

[@loo2400]

All of these tables would slow my workbook down and it’s crash every minute