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 –
Combined workbook with query –
Article on how to use Power Query –

Learn Power Query (complete tutorial):
If you are new to Power Query then watch this complete tutorial (80 minutes) to understand it fully.

Want more? Get my Power Query mini-course here

My Power Query tips & tricks playlist:
Here is a playlist of all my PQ tips & tricks. Binge responsibly 😉

Have a beautiful day

#PowerQuery #Excel


ClicGo Demo