Although helpful, this video just goes a bit too fast and I think covers quite a lot in a short time. I got lost at the "Applied Steps" stage in Power Query. If you simply want to merge lots of worksheets into one, without changing any columns etc etc, it would be really helpful, and possibly a clearer structure, if the tutorial simply explained that, before moving onto more complex things, such as performing the same operation but removing columns, etc.
I was able to create the Master combining the other Workbooks, but the Master is not updating once I click refresh? please help
Your instructions were fantastic! This was exactly what I needed.
Super helpful! I had to merge 52 weeks of csv files (1 per week), so this helped massively. Thank you.
wouah! thank you!!!
Thanks a lot. This was very helpful
Great information dear
Brilliant video. Thanks.
Is there a way to add additional data to certain fields based on another excel file?
Could you please tell me which office you used this to combine multiple sheets into one sheet ?
A big thanks!! Got it!
Is there a way to have the data from different sheets as sub columns rather than in different rows?
Thank you for your clear and quick instruction. So nice to not have to listed to a ton of jibberish, first. Thanks again!
Hello, Can we not consolidate the data in the same Excel workbook? And the consolidated sheet dynamically updates when data is added / changed to other sheets
This is my first time learning and I haven't tried yet, but can I have multiple folders or do all the files have to be in a singular folder?
Goodness!! This is very helpful. Thank you ao much. It's easy and straightforward, and there is no time wasting. That's exactly what i needed.
Thanks 🙏
My source don’t give me one query to combine the data
Is there any way to combine both of these methods. I need to import multiple excel sheets from multiple excel files all into one table.
@kamaboko1