Reconcile & consolidate data from multiple worksheets automatically using this amazingly simple Excel trick. You can set up a repeatable process so that every month Excel automatically combines the data for you.

⏱ In this video
==============
0:00 Introduction to the combine sheets problem
1:01 New file to consolidate the data
2:05 Updating "power query" steps
3:07 Cleaning up the combined data
5:35 Loading data to Excel
5:58 Testing with new data
6:48 More Power Query

Sample files
================

Download the sample clinic data here https://chandoo.org/wp/wpcontent/upl...
Combined workbook with query https://chandoo.org/wp/wpcontent/upl...
Article on how to use Power Query https://chandoo.org/wp/powerquerytu...

Learn Power Query (complete tutorial):
===============================
If you are new to Power Query then watch this complete tutorial (80 minutes) to understand it fully.    • Power Query Tutorial  What is it, ho...  

Want more? Get my Power Query minicourse here https://chandoo.org/wp/powerquerypo...

My Power Query tips & tricks playlist:
==============================
Here is a playlist of all my PQ tips & tricks. Binge responsibly ;)
   • Power Query Tutorial  What is it, ho...  

Have a beautiful day

#PowerQuery #Excel