Тёмный

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

Innozant
Подписаться 149 тыс.
Просмотров 22 тыс.
50% 1

Combine All Sheets in a File | Power Query Combine Awesome Method
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...
Music: www.bensound.com
===========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#combinefilepowerquery #innozant #powerquerytutorial#exceltutorial

Опубликовано:

 

30 авг 2021

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 115   
@hemantsingh9966
@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
@Innozant Год назад
Really means a lot to me dear..God bless You
@subrataghosh799
@subrataghosh799 2 года назад
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
@Innozant 2 года назад
Thanks Subrata.Hapoy learning ❤️God bless you
@santoshshirke9809
@santoshshirke9809 2 года назад
Good
@eajazahmad5925
@eajazahmad5925 22 дня назад
sir ji, May God Bless you a lot, you are fantabulous. Kindly share the solution video. We are awaiting eagerrrrrrly
@virendernegi7632
@virendernegi7632 2 года назад
Sir Aapke Teaching method ko salaam hai...sach me knowledge baatne se badhti hai...aap Uske live example ho..👍🙏
@Innozant
@Innozant 2 года назад
Thanks Virender ,Love you all .Have a wonderful career ahead ❤️
@bhasu446
@bhasu446 2 года назад
Excellent teaching. Really DIL SE.
@Innozant
@Innozant 2 года назад
Thanks Bhaskar Ji itne valuable comment ke liye . Really means a lot to me
@abhishekshirsekar2065
@abhishekshirsekar2065 2 года назад
Thanks a sir for valuable support and knlowdge
@Innozant
@Innozant 2 года назад
Thanks Abhishek Ji❤️
@sandeepaswal8944
@sandeepaswal8944 2 года назад
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
@Innozant 2 года назад
Thanks Aswal Sahab..God bless you.Have. A great career ahead.
@Narendar.pathak
@Narendar.pathak 2 года назад
Eagerly waiting for next part of this
@Innozant
@Innozant 2 года назад
❤️👍
@eighttech
@eighttech 5 месяцев назад
Thanks 😊
@krnrajan
@krnrajan 6 месяцев назад
Amazing. Can you share the solution to the twist. I could not locate the same anywhere. Thanks again. You are too good
@user-rm4cg2zn6x
@user-rm4cg2zn6x 4 месяца назад
Good Afternoon Sir, Excellent
@satishojha6240
@satishojha6240 2 года назад
Behtareen video sir 🙏🙏🙏
@Innozant
@Innozant 2 года назад
Thanks Satish Ji
@vijaysahal4556
@vijaysahal4556 2 года назад
Useful information 👍🏻👍🏻👍🏻👍🏻
@Innozant
@Innozant 2 года назад
Thanks Vijay ji..Happy Learning
@kishorpanara4191
@kishorpanara4191 2 года назад
Thank you my dear Sir
@Innozant
@Innozant 2 года назад
Thanks Dear❤️
@darylmendonca874
@darylmendonca874 Год назад
Wow... I've practiced it now it would've simplified my work
@Innozant
@Innozant Год назад
👍
@rakeshmlearningentertainme6099
@rakeshmlearningentertainme6099 2 года назад
nice video sir
@createyour6681
@createyour6681 2 года назад
Very great sir
@Innozant
@Innozant 2 года назад
Thanks
@Samelifesamethinking2345
@Samelifesamethinking2345 2 года назад
Omg wow I can't believe sir jee magic' ho gya maine socha aaj aur aapne vidio upload kr diya
@Innozant
@Innozant 2 года назад
Oh aisa kya😀Good hai. Thanks .Happy Learning ❤️
@manojkumarsingh3385
@manojkumarsingh3385 2 года назад
Great Video 🙏🏻🙏🏻🙏🏻🙏🏻
@Innozant
@Innozant 2 года назад
Thanks dear
@sonukumarskp6933
@sonukumarskp6933 Год назад
Masterpiece
@Innozant
@Innozant Год назад
Thanks Sonu
@shreeram90861
@shreeram90861 2 года назад
Thanks sir 🔥
@Innozant
@Innozant 2 года назад
Thanks Sharma ji
@aqeelahmadengr3
@aqeelahmadengr3 2 года назад
Sir you are good teacher.
@Innozant
@Innozant 2 года назад
Thanks Dear❤️
@darylmendonca874
@darylmendonca874 Год назад
The best thing about this is Dynamic data...
@Innozant
@Innozant Год назад
👍❤️
@alpeshpanchal7994
@alpeshpanchal7994 2 года назад
Superb
@Innozant
@Innozant 2 года назад
Thanks Alpesh ji
@pa2happiness13
@pa2happiness13 2 года назад
💞👌🏼
@meriawaazhindi5217
@meriawaazhindi5217 Год назад
❤️❤️❤️❤️❤️
@arunsandhu3087
@arunsandhu3087 2 года назад
I'm the first one for comments 🤠
@Innozant
@Innozant 2 года назад
Thanks Arun..Happy learning ❤️
@RahulChauhan-ll9pu
@RahulChauhan-ll9pu 2 года назад
🙏🙏👍👍
@jayantabhattacharyya628
@jayantabhattacharyya628 2 года назад
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
@Innozant 2 года назад
Thanks Jayanta.. Solution for this soon❤️
@rhashmi1
@rhashmi1 2 года назад
Zabardast
@Innozant
@Innozant 2 года назад
Thanks Rashid sahab
@durgeshrai8938
@durgeshrai8938 2 года назад
🙏🙏
@Innozant
@Innozant 2 года назад
Thanks Durgesh Ji
@Amank3107
@Amank3107 2 года назад
Wooowww
@Innozant
@Innozant 2 года назад
Thanks Aman ji
@jaspritsingh8228
@jaspritsingh8228 2 года назад
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
@Altaf_Alam 3 месяца назад
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...
@AnjaliYadav-vw3nl
@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?
@nileshchavan742
@nileshchavan742 2 года назад
👍🙏
@Innozant
@Innozant 2 года назад
Thanks
@akshatgoyal2473
@akshatgoyal2473 2 года назад
Please make videos on power query & Power pivot series on Priority basis I am eagerly waiting for the next lesson
@Innozant
@Innozant 2 года назад
Sure❤️
@muhammadasad9394
@muhammadasad9394 Год назад
Bro I have a question, if we combine sheets and we have different data in each sheet than how to transform
@susheeldobhal
@susheeldobhal 2 года назад
Sir power query editor me header ke niche green color ki line hai error baar ki office 2019 me kaise enable hogi wo?
@MohanSingh-df8bi
@MohanSingh-df8bi Год назад
Po Get data option not visible on my Excel please help how to show it
@devkunal1
@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
@Innozant Год назад
@innozantofficial telegram id
@horrorlovestories
@horrorlovestories 2 года назад
Sir extract aur text filter mein kya difference hai ?
@user-wf8qq8ut2s
@user-wf8qq8ut2s 5 месяцев назад
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.
@tejpalsain1507
@tejpalsain1507 2 года назад
,👍🌺
@Innozant
@Innozant 2 года назад
Thanks Tejpal ji
@shabanali9543
@shabanali9543 2 года назад
Multiple googl worksheet ko combine kaise kare with power query single click as you teach in exel videos just
@krishnendumaity4457
@krishnendumaity4457 2 года назад
Umid tha...Umid pura hone bala he...sir, up ne jab suru kardiaa he..
@Innozant
@Innozant 2 года назад
Thanks dear..God bless you
@shankarchavan1163
@shankarchavan1163 2 года назад
Sir ji macro pe video banao na
@Innozant
@Innozant 2 года назад
Ok Macro par bhi bnenge videos
@horrorlovestories
@horrorlovestories Год назад
Sir use original column as prefix option kab uncheck nahi karna hota hai?
@Innozant
@Innozant Год назад
Uncheck nhi krenge to whi field ka name le lega
@AbhishekKumar-gm1ye
@AbhishekKumar-gm1ye 2 года назад
Sir app google sheet pr bhi kuch bataya karo jee
@Innozant
@Innozant 2 года назад
Sur Abhishek Ji bht jald start krenge series dear
@situsahoo2482
@situsahoo2482 2 года назад
Yeah ..Ab Hogi Power office mein 💪💪💪.chut ki se jhat se bade data ko combine to one pager.I enjoy this assignment. 💥💥
@Innozant
@Innozant 2 года назад
Hahaha.. Thanks dear❤️
@allinonewithaks9496
@allinonewithaks9496 2 года назад
2nd
@Innozant
@Innozant 2 года назад
Thanks dear ❤️
@vimaldewangan9309
@vimaldewangan9309 2 года назад
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
@Innozant 2 года назад
Haan ho skta hai.kisi video me add krte hu ise
@vimaldewangan9309
@vimaldewangan9309 2 года назад
@@Innozant sir please provide the video
@shreeram90861
@shreeram90861 2 года назад
Sir ji vating for vba🙏🙏
@Innozant
@Innozant 2 года назад
Kuch time baad
@ankitjindaljulana
@ankitjindaljulana 2 года назад
So nice sir ji Sir, I want to attend offline classes Please tell me ur offline centers locations. I am from Jind (Haryana)
@Innozant
@Innozant 2 года назад
Dear Ankit kindly connect us via whatsapp/call for more details about offline classes (contact details are available in Innozant website)
@rahuljindalhr
@rahuljindalhr 2 года назад
@@Innozant ok sir Thanku so much
@Techwithmzh
@Techwithmzh Год назад
Next video link please
@horrorlovestories
@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
@asharfali9029
@asharfali9029 Год назад
900 sheet ko merge kana hai to kar sakta hai
@Altaf_Alam
@Altaf_Alam 2 месяца назад
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
@yogeshrao5924 18 часов назад
Ye nhi ho skta
@shaileshparmar175
@shaileshparmar175 2 года назад
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
@Innozant 2 года назад
Use Power query
@jkyadav77
@jkyadav77 2 года назад
how to crack mis exe. inter view for vba and macro......plz. start as soon as possible to on these chapter
@Innozant
@Innozant 2 года назад
Sure dear
@jkyadav77
@jkyadav77 2 года назад
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
@subhamsingh3374 Год назад
sab kuch Karne ke bad end me Close and load to ke baad pivot table ka option nahi ata h mere excel me
@abhichauhan10
@abhichauhan10 2 года назад
Sir aage ki video kab ayegi. I m waiting
@Innozant
@Innozant 2 года назад
Jald aayegi dear....kuch tike se health issue that's why kam videos aa re h
@abhichauhan10
@abhichauhan10 2 года назад
@@Innozant Oh.. we will pray for your health and get well soon..
@raviprakashgupta972
@raviprakashgupta972 Год назад
It is not working in MS Office 2013
@ubaidillahmuhammad20
@ubaidillahmuhammad20 2 года назад
Download File for Practice -Direct Link... wait it sir
@Innozant
@Innozant 2 года назад
Updated dear
@asharfali9029
@asharfali9029 Год назад
Please tell me
@Harish.Prasad.Semwal
@Harish.Prasad.Semwal 4 месяца назад
8:53 (9:41) Expression error
Далее
Merge Tables Using Power Query | Vlookup Alternative
13:43