AWESOME Excel trick to combine data from multiple sheets

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=k_ugshJ4wIw

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/wp-content/upl... • Combined workbook with query - https://chandoo.org/wp/wp-content/upl... • Article on how to use Power Query - https://chandoo.org/wp/power-query-tu... • 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 mini-course here 👉 https://chandoo.org/wp/power-query-po... • 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

#############################

New on site