Combine All Sheets in a File | Power Query Combine Awesome Method

[@hemantsingh9966]

Gurujii... You said 'Universe(Brahmanda) ' once in your video. Yes, Excel is like Universe. And this Universe of Excel is inside Your Universe. You are the Guru of this Universe of Excel... Pranaam 🙏🙏🙏

[@Innozant]

Really means a lot to me dear..God bless You

[@virendernegi7632]

Sir Aapke Teaching method ko salaam hai...sach me knowledge baatne se badhti hai...aap Uske live example ho..👍🙏

[@Innozant]

Thanks Virender ,Love you all .Have a wonderful career ahead ❤️

[@subrataghosh799]

Sir your way of teaching attracts me every time...you are so good. Before subscribing your channel I would search so many videos to learn excel...But in my view none can teach better than innozant. Beside this the way of teaching is so good. I have learnt so many things from you sir. Please keep teaching us sir and help us to improve our skills...

[@Innozant]

Thanks Subrata.Hapoy learning ❤️God bless you

[@santoshshirke9809]

Good

[@aishwaryajain5322]

Amazing, really appreciate your efforts.

[@bhasu446]

Excellent teaching. Really DIL SE.

[@Innozant]

Thanks Bhaskar Ji itne valuable comment ke liye . Really means a lot to me

[@satishojha6240]

Behtareen video sir 🙏🙏🙏

[@Innozant]

Thanks Satish Ji

[@aqeelahmadengr3]

Sir you are good teacher.

[@Innozant]

Thanks Dear❤️

[@L.mkidifrentlife1435]

Omg wow I can't believe sir jee magic' ho gya maine socha aaj aur aapne vidio upload kr diya

[@Innozant]

Oh aisa kya😀Good hai. Thanks .Happy Learning ❤️

[@sandeepaswal8944]

Sir great tutorial I've learnt much from the Power Query course. You're way of explaining things is magical. My awesome teacher Thanks a lot.

[@Innozant]

Thanks Aswal Sahab..God bless you.Have. A great career ahead.

[@AnjaliYadav-vw3nl]

I use to get data from 2 different text files in unorganised form, partial data of first line in 2nd or 3rd line beginning. How i can store that data in first line under their belonging headers?

[@Md.Ismail-v1e]

Good Afternoon Sir, Excellent

[@vijaysahal4556]

Useful information 👍🏻👍🏻👍🏻👍🏻

[@Innozant]

Thanks Vijay ji..Happy Learning

[@createyour6681]

Very great sir

[@Innozant]

Thanks

[@muhammadasad9394]

Bro I have a question, if we combine sheets and we have different data in each sheet than how to transform

[@manojkumarsingh3385]

Great Video 🙏🏻🙏🏻🙏🏻🙏🏻

[@Innozant]

Thanks dear

[@jaspritsingh8228]

First of all, I would like to thank you from the bottom of my heart for making such detailed videos on excel, thank you so much sir!! Secondly, the "mydata" workbook does not contain region wise column,so how is that appearing automatically in the power query?? do we need to add that column in the "mydata" workbook and then do power query??

[@Altaf_Alam]

In power query we are using sheet name as a extra column "region". Therefore we don't need to add a new column for region...

[@krnrajan]

Amazing. Can you share the solution to the twist. I could not locate the same anywhere. Thanks again. You are too good

[@MohanSingh-df8bi]

Po Get data option not visible on my Excel please help how to show it

[@pankaj3907]

Aa gai baat samajh me😊.

[@abhishekshirsekar2065]

Thanks a sir for valuable support and knlowdge

[@Innozant]

Thanks Abhishek Ji❤️

[@kishorpanara4191]

Thank you my dear Sir

[@Innozant]

Thanks Dear❤️

[@devkunal1]

Have tried same method in my Mac but this was not worked for me, kindly advise how to connect with you to understand

[@Innozant]

@innozantofficial telegram id

[@eajazahmad5925]

sir ji, May God Bless you a lot, you are fantabulous. Kindly share the solution video. We are awaiting eagerrrrrrly

[@arunsandhu3087]

I'm the first one for comments 🤠

[@Innozant]

Thanks Arun..Happy learning ❤️

[@Narendar.pathak]

Eagerly waiting for next part of this

[@Innozant]

❤️👍

[@santoshkumar-ud7jb]

Very nice

[@eighttech]

Thanks 😊

[@princerana6679]

Great Sir

[@jayantabhattacharyya628]

Dear Sir Superb power query tutorial for combine all sheets in a file. Earlier two combine methods are as easy as this. But here comes the twist in the video. I think total columns in both files (combined sheet & last added sheet) are not same in numbers & column name. Eagerly waiting for the solution to the twist. Thanks & Regards Jayanta Bhattacharyya

[@Innozant]

Thanks Jayanta.. Solution for this soon❤️

[@darylmendonca874]

Wow... I've practiced it now it would've simplified my work

[@Innozant]

👍

[@manojfriend-e7j]

I have one query hope you will help to resolve it. I have 7 workbook with different sheets and with different head, but in all sheets one information is common and all sheets have multiple transaction lines of single transaction. I want to create relationships among all sheets.

[@susheeldobhal]

Sir power query editor me header ke niche green color ki line hai error baar ki office 2019 me kaise enable hogi wo?

[@darylmendonca874]

The best thing about this is Dynamic data...

[@Innozant]

👍❤️

[@rakeshmlearningentertainme6099]

nice video sir

[@horrorlovestories]

Sir extract aur text filter mein kya difference hai ?

[@Altaf_Alam]

Sir i have a question so kindly reply 😊 1. How can we create connections only on multiple tables at once through power query? Plz reply sir 🙏

[@yogeshrao5924]

Ye nhi ho skta

[@shreeram90861]

Thanks sir 🔥

[@Innozant]

Thanks Sharma ji

[@alpeshpanchal7994]

Superb

[@Innozant]

Thanks Alpesh ji

[@akshatgoyal2473]

Please make videos on power query & Power pivot series on Priority basis I am eagerly waiting for the next lesson

[@Innozant]

Sure❤️

[@vimaldewangan9309]

Sir kya ham sheet 1 me jo bhi work kare data enty cell merge unmerge to vo another sheet me same entry hona chahiye aisa ho sakta hai kya

[@Innozant]

Haan ho skta hai.kisi video me add krte hu ise

[@vimaldewangan9309]

@@Innozant sir please provide the video

[@horrorlovestories]

Sir use original column as prefix option kab uncheck nahi karna hota hai?

[@Innozant]

Uncheck nhi krenge to whi field ka name le lega

[@sonukumarskp6933]

Masterpiece

[@Innozant]

Thanks Sonu

[@shabanali9543]

Multiple googl worksheet ko combine kaise kare with power query single click as you teach in exel videos just

[@shaileshparmar175]

Hi, muje heavy data pe kam krna hota he Like 4lakh row ki 10 15 file or use combined kr k pivot me kam krna but vo nai ho pa raha he Koi solution he to batao

[@Innozant]

Use Power query

[@rhashmi1]

Zabardast

[@Innozant]

Thanks Rashid sahab

[@horrorlovestories]

Sir expression error kaise solve karein is video ka continuation video nahi mil raha - maine power pivot playlist bhi check ki par nahi mila Plz help sir

[@ankitjindaljulana]

So nice sir ji Sir, I want to attend offline classes Please tell me ur offline centers locations. I am from Jind (Haryana)

[@Innozant]

Dear Ankit kindly connect us via whatsapp/call for more details about offline classes (contact details are available in Innozant website)

[@rahuljindalhr]

@@Innozant ok sir Thanku so much

[@asharfali9029]

900 sheet ko merge kana hai to kar sakta hai

[@tajumir48]

❤❤❤

[@meriawaazhindi5217]

❤️❤️❤️❤️❤️

[@jkyadav77]

Using pivot table find Total any no ODR ID Count AND Total Unique no is repeated and some are unique ODR ID COUNT no are duplicate 2 or 3 time and some are unique Mobile No wise in the Same Pivot Table i have use dis . count but not possible

[@subhamsingh3374]

sab kuch Karne ke bad end me Close and load to ke baad pivot table ka option nahi ata h mere excel me

[@pa2happiness13]

💞👌🏼

[@jkyadav77]

how to crack mis exe. inter view for vba and macro......plz. start as soon as possible to on these chapter

[@Innozant]

Sure dear

[@raviprakashgupta972]

It is not working in MS Office 2013

[@situsahoo2482]

Yeah ..Ab Hogi Power office mein 💪💪💪.chut ki se jhat se bade data ko combine to one pager.I enjoy this assignment. 💥💥

[@Innozant]

Hahaha.. Thanks dear❤️

[@RahulChauhan-ll9pu]

🙏🙏👍👍

[@AbhishekKumar-gm1ye]

Sir app google sheet pr bhi kuch bataya karo jee

[@Innozant]

Sur Abhishek Ji bht jald start krenge series dear

[@krishnendumaity4457]

Umid tha...Umid pura hone bala he...sir, up ne jab suru kardiaa he..

[@Innozant]

Thanks dear..God bless you

[@durgeshrai8938]

🙏🙏

[@Innozant]

Thanks Durgesh Ji

[@shankarchavan1163]

Sir ji macro pe video banao na

[@Innozant]

Ok Macro par bhi bnenge videos

[@shreeram90861]

Sir ji vating for vba🙏🙏

[@Innozant]

Kuch time baad

[@Techwithmzh]

Next video link please

[@nileshchavan742]

👍🙏

[@Innozant]

Thanks

[@abhichauhan10]

Sir aage ki video kab ayegi. I m waiting

[@Innozant]

Jald aayegi dear....kuch tike se health issue that's why kam videos aa re h

[@abhichauhan10]

@@Innozant Oh.. we will pray for your health and get well soon..

[@Harish.Prasad.Semwal]

8:53 (9:41) Expression error

[@ubaidillahmuhammad20]

Download File for Practice -Direct Link... wait it sir

[@Innozant]

Updated dear

[@Amank3107]

Wooowww

[@Innozant]

Thanks Aman ji

[@tejpalsain1507]

,👍🌺

[@Innozant]

Thanks Tejpal ji

[@allinonewithaks9496]

2nd

[@Innozant]

Thanks dear ❤️

[@asharfali9029]

Please tell me