AWESOME Excel trick to combine data from multiple sheets



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.

My Power Query tips & tricks playlist:
==============================
Here is a playlist of all my PQ tips & tricks. Binge responsibly ๐Ÿ˜‰

Have a beautiful day ๐Ÿ˜€๐ŸŒผ๐ŸŒž

#PowerQuery #Excel

Source: zero24-7.org

See also  INTERACTIVE EXCEL DASHBOARD in less than 5 minutes | Dynamic reports, charts & slicers

36 comments on AWESOME Excel trick to combine data from multiple sheets

  1. I want outlook to send recurring email with an excel attachment everyday. The excel is power query enabled which loads the data automatically on daily basis. Please support.

  2. Great, and clean, I only see the problem that if the June Tab is removed the PowerQuery breaks. because you rename Jun21 to Month, maybe is better rename de columns instead promote.

  3. In larger data there's always an error pop up when close and load to table, please assist how to resolve that issue.

  4. Helpful video. Thank you!
    Could you please make one video on that how to split multiple excel files from one master excel file.
    Example: if we have multiple tabs in main excel sheet and we want to make them separate excel file.

  5. Hello Chandoo
    I want your help in making same type of pivot charts for different excel files can u make a video on this

  6. This is really helpful for me thank you chandooooooโคโคโคโคโคโœŒโœŒ๐Ÿ’๐Ÿ’

  7. Sir can u explain the same automation when the columns are different for different excel sheets but number of columns are same and we want to combine them

  8. Great and thanks a lot for that. Can we extend this trick to data from folder rather than single excel workbook..? Anything for doing that would be also helpful. Thanks once again.

  9. Chandoo I love your videos, it appears that the data type for date column was passed as text and presented as the date serial number. Any good ways to change this upon close and load?

  10. Hello sir
    I want to become a data analyst. I don't know from where should I start and which course is best. Please help sir

  11. Loved how you added background music and small sound effects to the video. It made the watching more pleasant. Really good work and ofcourse the content was helpful.

  12. amazing Mr. chandoo thank you for it .but notice this music in the back knowing us as not native English I'm Arabic man . sorry for interrupting you .

  13. Hello sir, i have data of more than 4k employees , i have filter the employees based on some criteria and brought other data beside it by vlookup(from other sheet ) , but when i try to copy and past it the values using past sp. Not able to see the values because of filter.. please help me Thank you

  14. Hello Chandoo- I am using excel 2016 standard version, which doesn't have a power pivot, how can I create a pivot table from two tables having duplicate values in each table, I cannot create a relationship as that would require unique values in at least one table.

  15. Hello Chandoo- I am using excel 2016 standard version, which doesn't have a power pivot, how can I create a pivot table from two tables having duplicate values in each table, I cannot create a relationship as that would require unique values in at least one table.

  16. Actually graduation 3 years only my graduation is 6 years but I interested software job i worked in school as a science teacher right now I am learning SQL n Power BI is possible r not for getting job

    Waiting for your response.

Leave a Reply

Your email address will not be published. Required fields are marked *