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

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

Thankyou for coming up with such detailed video.

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

Very clear and concise! Thank you!

Wonderful information. Really a step up from excel 2003 !

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

Amazing Playlist. gives good knowledge about Power Query

Very precise and Clear, thanks for an amazing video

You rock! saved the day!

Thanks so much.

Thank you

Thank you so much

Very informative video

thanx

Thanks!

muy util!!! muchas gracias!! :)

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

Thank u

U r gorgeous boss !!!❤❤❤

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.

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

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

Getting error in date cloumn