12 - Combine Tables from Different Workbooks into One Table in Excel (Using Power Query)

In this video, I will show you how to combines tables from multiple workbooks into a single table using Power Query
✅ Power Query Course Download files: bit.ly/power-query-download
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: th-cam.com/users/trumpexc...
#Excel #PowerQuery #ExcelTips

[@gmsubu]

Your explanation is lucid. Thanks for it. I could learn Excel pivot query fairly well.

[@aishwaryabhagat1333]

Thankyou for coming up with such detailed video.

[@ranjan_v]

Very precise and Clear, thanks for an amazing video

[@kiranpatel2912]

Very clear and concise! Thank you!

[@mohitmanwani5298]

Amazing Playlist. gives good knowledge about Power Query

[@kinchannel3264]

It is useful and straightforward.. very simple ❤.. thx

[@spotfireuser]

Wonderful information. Really a step up from excel 2003 !

[@TVSCDN]

Thanks a lot sir.... please also explain how best to locate n identify files🎉😮😊 as this creates confusion

[@gargrish]

You rock! saved the day!

[@alfredotrucchia2122]

muy util!!!
muchas gracias!! :)

[@akashmon5065]

Thank you so much

[@Exceltrick4u]

Very informative video

[@FRANKWHITE1996]

Thanks!

[@margad-erdeneboldbaatar4704]

Thanks so much.

[@ChrisKalil-id2ki]

thanx

[@GV-gn3mj]

Thank you

[@karthikrajgopal8627]

Thank u

[@vijaybrahmbhatt5281]

U r gorgeous boss !!!❤❤❤

[@PATIJPTKTRN]

In my Excel desktop application. Excel tables do not appear in the power query navigator tab. What will be the issue?

[@really_sachin]

Hi, I have multiple Excel files which has 7 worksheets. Now all workbooks have same worksheets with same name but data is different relating to different people. I want to combine same worksheet name data from different workbooks in a new workbook but having multiple worksheets again. I just want sheetwise consolidated data in a new workbook. Is there anyway to do this in one go or do i need to follow same query steps for all the worksheets? I am in dire need of this solution.

[@youngistaanmerijaan]

I have 20 .csv file in a folder and i want merge all with power query...but problem is all file names are ending with .csv_ (i.e. reader7.csv_ and reader8.csv_ )...please help me how can i remove all underscores from all file simultaneously....because without removing underscore power query is not detecting format....

[@9620486126]

Getting error in date cloumn

[@kinchannel3264]

What if we have one month data and need to give one consolidated table ?

[@kinchannel3264]

Then, we have to make query from folder and choose all the sheets, is it like that, or u have another way?