Append Data from Multiple Workbooks into One Table in Excel Using Power Query

Рет қаралды 23,322

3 жыл бұрын

Append Data from Multiple Workbook into One | Combine Data from Different Workbooks into One Table in Excel using Power Query
Excel Power Query Playlist Link- • Excel Power Query
Download the Assignment Master Practice Folder here (All Playlist Example at one place) drive.google.com/drive/folder...
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.com/courses/adv-...
✅ Mastering Power BI Video Course
www.innozant.com/courses/powe...
✅ Mastering VBA Video Course
www.innozant.com/courses/vba-...
✅ Mastering SQL Video Course
www.innozant.com/courses/orac...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozantinfotech
#powerquery #powerqueryappend#innozant #getandtransformexcel

Пікірлер: 80

@govindapujari5720 Жыл бұрын

Thank you sir for providing all the practice sheets they are very helpful.

@abhinav10x Жыл бұрын

Great Great & Great, Thank you again.

@sandeepaswal8944 3 жыл бұрын

Very clear step by step tutorial, easy to understand, very helpful. Thank you so much Sir. You have helped me a lot. Thank you so much.

@Innozant 3 жыл бұрын

Thanks Sandeep ji ..Oh you started Power Seies learning..thats great

@shrikantbadge3978 Жыл бұрын

Amazing sir thank you

@kirandodke3647 3 жыл бұрын

kya badiya mathod le kr aaye sir sir aap to great ho

@Innozant 3 жыл бұрын

Thanks Kiran..Happy learning.God bless you dear

@ManishSingh-dn3ro 3 жыл бұрын

Awesome sir......you deliver your experience in the simplest and effective way......easy to learn and to the point..... good night 🌃🌃

@Innozant 3 жыл бұрын

Thanks Manish Jim.Happy Learning..Good Night dear.

@pratikshas7339 Жыл бұрын

Excellent explanation.thank u

@Innozant Жыл бұрын

Thanks Pratiksha.Happy Learning

@hsgusain2054 3 жыл бұрын

Thanks sir Ji

@Innozant 3 жыл бұрын

Thanks dear

@user-ic3jf5yl4c 5 ай бұрын

Sir i am from Bangladesh my name is Russel. Sir apka video me 2022 se dek rahaho, apka every video premium lakho rupee ki ha perbi apne mera jesa student ko free me sikateho jo mera liye bohot bara ehsan he. Or apka teaching skill wow sir. Apka video me view kam ata ha isiliye ap kabhi rukmat jana kiuki ap agar ruk jaoge to mera jesa student ko kiya hoga kiuki mera pas itna paisa nahi he ki koi course kharidlu.Me apka every video ka value ar kadar karti hu. Aisa in sequence youtube channel akbi nahi he. Best wishes for you sir. Love from Bangladesh.

@Innozant 5 ай бұрын

Don't worry.Keeo learning and keep growing

@mjaved701 3 жыл бұрын

Really appreciate your efforts, sir your method of teaching also so much amazing 🤓🤓🤓

@Innozant 3 жыл бұрын

Thanks Javed sahab for your valuable appreciation..🙏❤️

@jayantabhattacharyya628 3 жыл бұрын

Dear Sir Excellent tutorial. A new power query append method has been learned from your tutorial. Your way of teaching is very good and understandable. Hope to watch more useful tutorials on power query in near future. Thanks & Regards Jayanta Bhattacharyya

@Innozant 3 жыл бұрын

Thanks Jayanta...Power query series are top priority now.. Thanks

@ajaysaroha2539 3 жыл бұрын

Sir,you are great

@Innozant 3 жыл бұрын

Thanks Ajay.GN

@rakeshmlearningentertainme6099 2 жыл бұрын

super video sir

@RahulChauhan-ll9pu 3 жыл бұрын

Zebredast guru ji 👍

@Innozant 3 жыл бұрын

Thanks Rahul..Gn

@ShakeelAhmed-kk1fk 3 жыл бұрын

Very nice sir you are great

@Innozant 3 жыл бұрын

Thanks Shakeel ji

@satishojha6240 3 жыл бұрын

Vert effective sir good morning🌞🌞

@Innozant 3 жыл бұрын

Good afternoon Satish ji🙏❤️

@arghyadutta9091 Жыл бұрын

Great

@mjaved701 3 жыл бұрын

Excellent

@Innozant 3 жыл бұрын

Thanks Javed Ji🙏❤️

@rkrajeev2357 2 жыл бұрын

Thanks for such easy explanation. I am still new to excel learning. My query is, in this video at 9.34 minute, where did you " close" from ?

@kishorpanara4191 3 жыл бұрын

Excellent sir l ❤️💙💛 U

@Innozant 3 жыл бұрын

Thanks Kishor

@horrorlovestories 2 жыл бұрын

Sir =Excel.CurrentWorkbook() vs =Excel.Workbook Ye dono formula mein difference kya hai aur in dono mein se .workbook aur current workbook kahaan add karna hota hai?

@amandeepbadgujjar7096 10 ай бұрын

Hii good morning sir, first of fall you are doing great job and thanks sir for your all fabulous content, I always watch your video and learn something new every day, sir actually I want to ask that I have 3 workbook and I have merged of 3 workbook into one table, sir incase my one workbook delete so can I view the record data into that merged table, of that delete workbook?

@pardawala_Bhiwandi 3 жыл бұрын

Wow 👍👍👍👍👍👍

@Innozant 3 жыл бұрын

Thanks Santu

@santhoshgowda5727 2 жыл бұрын

Can you do one more sir, like different workbook and different sheets with some different header and some same... How to combine those similar heads data..

@riteshmishra559 3 жыл бұрын

Difference between power query and power BI pls explain sir.

@Innozant 3 жыл бұрын

Kindly watch video available in playlist career guide for the same

@maheshdoke8181 2 жыл бұрын

Parameter Explain pls

@attiafatima9096 7 ай бұрын

what if i delete the source data file? will it delete my all work done via power query?

@anandbobade52 2 ай бұрын

How to get it done if Rows are more than 10 lakh in combined worksheets

@ronnyrwttyt4434 3 жыл бұрын

❤️❤️

@Innozant 3 жыл бұрын

Thanks Ronny..tc.gn

@ronnyrwttyt4434 3 жыл бұрын

@@Innozant sir you are my inspiration ❤️

@Innozant 3 жыл бұрын

Thanks dear..Mehnat kriye jaroor successful honge life m

@ronnyrwttyt4434 3 жыл бұрын

Sir aapke jaise bnna h life hai. ❤️

@Innozant 3 жыл бұрын

Aur bhi behtar banenge dear..nvr stop learning..god bless you

@e-lessionforchangelife2898 Жыл бұрын

Sir, I am trying to combine the files but the error is showing "DataFormat.Error: The input couldn't be recognized as a valid Excel document." Please check

@gauravbhatia7987 3 жыл бұрын

🙏🙏🙏🙏

@Innozant 3 жыл бұрын

🙏❤️

@prashanttyagi1156 3 жыл бұрын

Sir Please ik baat bataye. Agar workbook alag alag hain aur sab mein colum header bhi alag alag hai kya wo bhe ho jayega . Yaa column header aur colum number sab workbook mein same he hona chahiye. Jaise kisi workbook mein colum a,b,c mein header hai doosre workbook mein colum d,e,f mein header hai aur aise aur workbook mein ho to kaise hoga

@Innozant 3 жыл бұрын

Problem creat krega ydi same nhi higa to duplicate seprate bnayega phir..maine bataya hua hai kis situation me alag rakh sakte hain header aur kab nahi

@shaikh9394 2 жыл бұрын

Sir is main koi requirement to nahi hai na keh hamari sari sheets .xlsx main hee h0 ya kisi bhi extension main ho merge h0jaengi ..

@Innozant 2 жыл бұрын

Kisi me bhi ho.. filter kar leng extension apni requirement ke base par

@imranali-iy5wk 2 жыл бұрын

Sir aik workbook ma aik sheet ki jagha agar 10 sheets hon aur workbook bhi 10 hon tou kesay merge krain gay plz waiting your reply

@Innozant 2 жыл бұрын

Haan tab bhi kya prob hai ho jayega merge..powrr query series me aagea video iska

@imranali-iy5wk 2 жыл бұрын

@@Innozant sir ma nay dekhi ha sari video pr eska solution nai mila 2 sal say dhond raha hn kun ka sir hamary data entry operator jo excel ma data entry karty hain wo 10 log hain aur har aik ki workbook ma 10 sheets hoti hai zada bhi ho sakti hai tou jab data ko merge krna ho kisi aik excel file ma tou kafi time lag jata ha es pr video agr possible ho bna dain aur es mushkil sy nijat dain 😭

@aqibjaved6907 3 жыл бұрын

sir am not getting option three or more tables its showing single table option am using 2016 version

@Innozant 3 жыл бұрын

Which version you are using dear

@aqibjaved6907 3 жыл бұрын

@@Innozant microsoft office profesional version 2016, 16.0.4266.1003

@rahuljuyal4120 10 ай бұрын

new file kha p create hogi ... all files append hone k bad.( close and load p click krne k bad)

@NitinSharma-sr5rn 7 ай бұрын

Close and load new pe click

@vishalsahu7299 3 жыл бұрын

Ist view

@Innozant 3 жыл бұрын

❤️🙏🙏

@rabinghimire4675 2 жыл бұрын

Sir,ye 2013 me hai?

@Innozant 2 жыл бұрын

Yes .dear

@ravisrivastava6722 2 жыл бұрын

sir agar mere pass BAHUT JADA FILE HUWA EK HI FOLDER ME TO ONE TIME MAI KAISE COMPILE KARENGE

@Innozant 2 жыл бұрын

Filder import option available hai data tab me

@Rabbani_World_Flock 5 ай бұрын

Sir please jis workbook ya sheet ko use krte ho sirf usi ka link description me Diya Karo.... Because itne bade folder me file milta nahi please ❤❤🎉🎉 hum sabhi videos dekhte hai so🙏🙏

@Innozant 5 ай бұрын

Sure..in future will update it

@Rabbani_World_Flock 5 ай бұрын

@@Innozant Sure I will wait for that, because main aapka fan hu sir aapka style ekdam smjh m aata hai 🙏🙏