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

Рет қаралды 44,062

4 жыл бұрын

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: kzfaq.info...
#Excel #PowerQuery #ExcelTips

Пікірлер: 24

@gmsubu Ай бұрын

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

@aishwaryabhagat1333 9 ай бұрын

Thankyou for coming up with such detailed video.

@TVSCDN Жыл бұрын

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

@kiranpatel2912 11 ай бұрын

Very clear and concise! Thank you!

@ranjan_v 4 жыл бұрын

Very precise and Clear, thanks for an amazing video

@mohitmanwani5298 4 жыл бұрын

Amazing Playlist. gives good knowledge about Power Query

@kinchannel3264 10 ай бұрын

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

@spotfireuser 2 жыл бұрын

Wonderful information. Really a step up from excel 2003 !

@alfredotrucchia2122 4 жыл бұрын

muy util!!! muchas gracias!! :)

@gargrish Жыл бұрын

You rock! saved the day!

@Exceltrick4u 3 жыл бұрын

Very informative video

@akashmon5065 4 жыл бұрын

Thank you so much

@margad-erdeneboldbaatar4704 2 жыл бұрын

Thanks so much.

@ChrisKalil-id2ki 21 күн бұрын

thanx

@FRANKWHITE1996 4 жыл бұрын

Thanks!

@GV-gn3mj 4 ай бұрын

Thank you

@karthikrajgopal8627 4 жыл бұрын

Thank u

@vijaybrahmbhatt5281 7 ай бұрын

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 3 жыл бұрын

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....

@kinchannel3264 10 ай бұрын

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

@kinchannel3264 10 ай бұрын

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