Combining Non-Identical Sheets - Power Query Function - IM ◄► POSSIBLE

In this tutorial I show you how to combine any number of Worksheets where data is totally different in Size, location and lots of undesirable values.
I will clean, transform a sample sheet as a model. Then convert the query into a function that dynamically finds the desired values. By invoking the custom function we will combine any number of worksheets then visualize the data with pivot Tables, Chart and slicer.
You can download the Exercise File and Follow along by clicking on the link:
www.OfficeInstructor.com/public

You can learn everything about Pivot Tables by watching my FREE course:
Pivot Tables for Beginners- Complete Course with downloadable Files.
   • Excel Pivot Tables For Beginners - Co...  

Please do your part in supporting the OfficeInstructor channel : Like , Share, Comment, Subscribe and Ring the bell.