Power Query : Append Method | Combine Excel Worksheets in a Workbook using Power Query Append Method

[@pramodbhavsar4488]

Very Nice example of power query Append different sheet in power query explain by you thank you sir

[@helendroza3833]

Thank you Innozant for explaining it so well 😇

[@Innozant]

Thanks..Keep learning ❤️

[@tamalchakraborty5009]

Thank you so much... Your way of reaching is really great.

[@sandeepaswal8944]

Thank you sir. This course is awesome. Power Query is best reporting tool in Excel.

[@Innozant]

Yes..its is . thanks for your love and support ❤️❤️

[@kishorpanara4191]

Thanks sir muje power query knowledge nahi tha ab hi jaye ga sir again thanks

[@Innozant]

Thanks Kishor..step by step in detail upload honge videos

[@situsahoo2482]

SQL query se eai aacha laga.chutki se jhat se sab kam khatam.👍👍
Cracking explore..dilip sir.❤️

[@Innozant]

Thanks Sahoo ji..seekhte rhiye aur life me aage badhte rahiye dear

[@sunilsharmacricketgyan]

Sir is video ne to meri puri problem hi solve kardi

[@Innozant]

Are wah..good hai

[@sachingulati9857]

Thank you so much sir for making out these videos and explaining things in lehman's terms

[@Innozant]

Thanks Sachin ji🙏❤️

[@varindergarg2862]

SIR U HAVE CHANGED MY CONCEPT OF THINKING IN EXCEL 🙏

[@Innozant]

Thanks Varinder ❤..Happy learning dear

[@usamajaved5386]

Great work sir

[@TheSuvankarKundu]

Sooo helpful and worth watching❤... Bt..jst a qst.. Can we apply any formula in power query..?

[@mjaved701]

Excellent job sir

[@Innozant]

Thanks dear

[@hridayg6446]

Nice content

[@s.keshavmathur]

You are great sir🙏🙏🙏

[@Innozant]

Thanks Shiv

[@satishojha6240]

Well explain sir 👌👌 thanku 🙏🙏

[@Innozant]

Thanks Satish ji

[@chayanbhattacharya1736]

wonderful content

[@puransingh-sx2tk]

Nice sir Majedar topic

[@Innozant]

Thanks Puran ji

[@RohitKumar-cc7zi]

Good to see, great

[@Innozant]

Thanks Rohit Ji

[@shrikantbadge3978]

Amazing sir thank you

[@deepali303]

Great❤❤

[@Innozant]

Thanks Deepali..Good Morning

[@chimaaggarwal8909]

Sir isme koi new sheet add krte h wo same format mei honi chahiye kya

[@arunssairam]

Superb

[@ajaysaroha2539]

Thank you so much sir ❤️

[@Innozant]

Thanks Ajay ji

[@saiyadazazali3243]

superb,,,

[@sharingiscaring1378]

hi sir kindly share your link for excel classes sir your way of teaching is very impressive love from Pakistan

[@Innozant]

Dear Kanwal thanks for showing your interest to join us,You may join our Live Classroom Training via Zoom.

[@sharingiscaring1378]

@@Innozant sir how can i join and kindly send your email adress and whatsapp no thanx alot sir u r the world's best excel trainer

[@sharingiscaring1378]

@@Innozant kindly share email and whatsapp and also zoom link sir

[@jayantabhattacharyya628]

Dear Sir
Wonderful & amazing tutorial. Ultimately the magic of power query begins. I think it's steps are easier than excel. Can I use same excel function in power query?
Kindly upload tutorials on function in power query.
Thanks & Regards
Jayanta Bhattacharyya

[@Innozant]

Thanks Jayanata...Will upload more videos for the same

[@eighttech]

Thanks

[@aasimkazi9582]

Sir ek question tha agr hum pehle table ko name de uske bad append directly Kre toh without making connection aisa bhi ho Santa hai na sir pls pls pls pls reply sir

[@zainulabedin6368]

U have solved my problem ♥ I Am facing problem kindly solve . I have data on 2 workbooks same headings , 1st workbook headings date and name
2nd name and date
How to correct both? I cannot do in workbook I have tooo many books kindly help
Comment plz

[@rakeshmlearningentertainme6099]

nice video

[@rajdeepsaha9059]

Great

[@umeshroy6898]

mulltiple workbook combine karne se pahle data ko table me karna jaruri hai kya

[@Innozant]

Nbi bhi karenge to power query khud table me convert kar lega

[@vishvajeetthakar2409]

sir aap VBA ka tutorial start kariye na aapka style badhiya hay esy way me dimag me ghus jata hay please i huble requeat to you Start VBA COURCE

[@Innozant]

jaroor karenge dear pehle power series finish kar lete h.

[@vishvajeetthakar2409]

@@Innozant jab file merge kar but header alag alag ho or unko hame merge karna ho to?

[@mahmudulhaque1296]

Which version of Office Package you are using?

[@Innozant]

Earlier 2016 now office 365

[@WajidKhan-om6hw]

Sir mera ek question he agar hamare pass do sheet ho unme bahur safe coulems ho aur dono sheet ke data ko merge karna ho per ek sheet me Jo columns he vo unme sent kush columes dooshri sheet me nahi he aur Jo coloums dooshri sheet me he unme se kuch pehli sheet me nahi he Jo columns mach nahi ho rahe unme 0 ajaye to isko kese merge karenge kuch coloums age peeshe bhi ho sakte hen please sir batayen mujhe

[@Innozant]

Power query method ..Pivot table video series me maine karaya hai.. relationship ke baad wapa video dekhiye ek baar aap.phir btana usse help mila ki nhi

[@aasimkazi9582]

Matlab woh sheets mein jitne table hai sanko name dena ka bad without connection append kre toh kyuki power query jab upload kre hai kuch use directly connection bana dete hai na sir pls pls pls pls reply toh both doubt sir

[@Innozant]

Kya benifit hoga without connection append krne ka.. connection isliye bnate h ki use baad me kar saken data ka

[@SagarKumar-2891]

How to add columns and refresh data in power query append method

[@piyushrana3080]

Dear Sir, When I click on "close and load to..." Only two options are shown in the box, Table and Only create connection. PivotTable Report and PivotChart options are missing. I am using Excel 2016. What is the problem?

[@horrorlovestories]

Sir formula method mein header change kiya toh phir bhi error aayega?

[@Innozant]

Kyu..aisa homa nhi chaiye..step sahi follow kar rahe hain?

[@horrorlovestories]

@@Innozant nahi sir maine try nahi kiya main toh bas doubt clear kar rah tha, wahi confusion tha jo clear hua abhi.

[@akbarwarsi7327]

Sir agar koi nayi sheet add karte hai to use phir kaise add karenge please.... Sir.....

[@aishwaryajain5322]

I am not getting this only create connection option

[@sadashivkage3133]

🙏🙏

[@moinusaifi3164]

❤️❤️❤️

[@Innozant]

Thanks

[@aniketpalav9097]

Sir, I have excel 2016, but I have doubts regarding append.... when I click on "append".. its shows 2 lists of tables. 1) primary list 2) secondary list..... But how can I much all table/connection at one time....

[@sharingiscaring1378]

sir kindly reply i want to join your classes kindly guide me

[@Innozant]

You may mail or whatsapp us for more info

[@gamehub8068]

सर अगर 10 या 15 वर्क बुक है तो उसे भी ऐसे ही अपेंड कर सकते हैं???
और डेटा 10 लाख से ज्यादा हुआ तो भी??

[@Innozant]

Yes we can

[@kashisharora4563]

Sir, i want to ask one thing?
Sir ,10 lacs + 10lacs rows append krne pe null ara hai 20lacs total hona chahi hai wo ni hora hai
Please help me

[@Innozant]

Kuch galat step kar re hain kya?dono table ka connection bnaya hai na?

[@kashisharora4563]

@@Innozant yes sir connection bnaya hai

[@Innozant]

Phir kyu nhi ho raha hai..aap mukhe sheet mail kar dena..ya jb time free hoga to connect kr lenhe zoom live..will guide you.

[@kashisharora4563]

@@Innozant thank you for your time sir, i will mail you.

[@Innozant]

Ok..aapkr paas id hoga ..ya channel ke about section me dekh lo..koi issue ho to btana

[@Harish.Prasad.Semwal]

Append Query 6:52

[@AshishKumar-hc3km]

Mere me apend krte time table number pucha

[@Innozant]

jahan table rakha hai wo path dena tha

[@abhishekdixit5070]

Sir mujhe apka no chaiy mere sath ajeb ajeb exel prob ho jati h wo mujhe apse batana h

[@abhishekdixit5070]

Jayse ki apka rank wala function lagaya aapki exercise wali table par but apki jaysi rank nahi aa rahi

[@Innozant]

website se lein contact details

[@AshishKumar-hc3km]

Sir mere me nhi hua

[@Innozant]

kyu

[@ImranKhan-il9me]

agar mere pass 67 worksheets hain tou mein ek ek kar kay karoun gaa

[@Innozant]

Custom function use Karen excel workbook

[@kashifqasim8069]

Great