Тёмный

Merge Tables Using Power Query | Vlookup Alternative 

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

How to Merge Two or more Excel Tables Using Power Query | Vlookup Alternative
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
#mergerpowerquery#powerquery#innozant #powerquerystepbystep

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

 

2 май 2021

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 108   
@princekamboj1620
@princekamboj1620 2 месяца назад
one of the best channels on youtube for learning. Thanks a ton sir .
@Altaf_Alam
@Altaf_Alam 3 месяца назад
Wahh sir ji ... Bahot accha alternative h ye vlookup ka with connection establishment 😊❤
@ayazakhtar42
@ayazakhtar42 Год назад
You are really genius, the way of teaching and explaining is really splendid . I have learnt lot of from your videos.
@Innozant
@Innozant Год назад
Thanks Ayaz
@ArmaanKing17
@ArmaanKing17 Месяц назад
Thank you so much sir for making difficult concepts interesting 😊
@Innozant
@Innozant Месяц назад
Keep learning
@82asm
@82asm 2 года назад
Excellent presentation on this topic. Apka batane ka style bohat acha he interesting he aur easy he. Meri job me data manupolation bohat ziada he iss k lia power query seekh raha hun. Apki video bojat easy hoti he i enjoyed everyone of them keep producing good content. Aik video power query ki limitions pe bhi banaden. Aor ye bhi bataden k power query me maximum kitini instructions add hosakti hein. Thanks.
@Innozant
@Innozant 2 года назад
Thanks Asim Sahab for your valuable appreciation..Haan Air videos aayeng power Query ke
@VipulJain40
@VipulJain40 Год назад
wahh Guruji .. Tussi Great ho .. Kab se dhund raha tha ye content
@Innozant
@Innozant Год назад
Thanks Viul👍
@acommonman155
@acommonman155 Год назад
Nice & Easy Explanation GURU JI 🙏
@pramodbhavsar4488
@pramodbhavsar4488 3 года назад
Very nice explained with example different data in sheet Append and merge and create pivot table create coloum with creating relationship very nice techniques of merge coloum in pivot table thank you sir
@Innozant
@Innozant 3 года назад
Thanks Pramod Ji..Hope you like and learn from this
@jyotiprasadchaudhary8527
@jyotiprasadchaudhary8527 Год назад
Wow......I have learned. Credit goes to u brother.
@Innozant
@Innozant Год назад
Thanks Jyoti.Keep learning 👍❤️
@pravinkumbhare1750
@pravinkumbhare1750 8 месяцев назад
🎉 concept clear ho Gaya sir, thanks..
@devangthakkar6847
@devangthakkar6847 2 года назад
Dear Sir, Superb Power query tutorial. Thanks for updates.
@Innozant
@Innozant 2 года назад
Thanks Devang sahab
@SAJJADAHMAD-uy3hu
@SAJJADAHMAD-uy3hu 2 месяца назад
yes common columns are available in these table. These columns are Policy and sales Rep. Policy between first and second table and Sales Rep between first and third column.
@impawansaini08
@impawansaini08 2 года назад
Sir merge query is most powerful tool rather then vloookup or index match clearly understand concept of merge query 🙏🙏🙏
@ExcelZone
@ExcelZone 3 года назад
Sir, watched both videos of tips and tricks but not found alternate columns cell addition. And learnt lot of from that video. But also think about that. Thank you so much sir
@Innozant
@Innozant 3 года назад
Thanks Surender ji
@avinashverma52
@avinashverma52 2 года назад
Great and very easy explanation .
@Innozant
@Innozant 2 года назад
Thanks Avinash Ji
@helendroza3833
@helendroza3833 Год назад
You teach so well 🙏🏻
@Innozant
@Innozant Год назад
Thanks dear
@heeralalkumawat2132
@heeralalkumawat2132 Год назад
Sir🎉❤❤❤❤ Ye video mere bhut kaam aayega
@Innozant
@Innozant Год назад
Thanks
@hemantsharma4896
@hemantsharma4896 Год назад
fantastic Videos 🙏🙏🙏
@jayantabhattacharyya628
@jayantabhattacharyya628 3 года назад
Dear Sir Superb power query tutorial. Useful Alternative way for VLOOKUP function. It is very effective to use power query merge option instead of Vlookup function. Good bye VLOOKUP function from today & I am welcoming power query merge option instead of it. Thanks & Regards Jayanta Bhattacharyya
@Innozant
@Innozant 3 года назад
Thanks Jayanta for your appreciation..God bless you..Happg Learning dear
@abhinav10x
@abhinav10x Год назад
Thank you
@kishorpanara4191
@kishorpanara4191 3 года назад
Maza aa gaya sir your work excellent thanks sir
@Innozant
@Innozant 3 года назад
Thanks Kishor..❤️🙏
@shrikantbadge3978
@shrikantbadge3978 Год назад
Amazing thank u sir
@AnkitMishra-so5qo
@AnkitMishra-so5qo 3 месяца назад
Thank you 🎉
@rockfighter9974
@rockfighter9974 Год назад
Really nice video
@navnathborade
@navnathborade Год назад
Nice and thank
@mjaved701
@mjaved701 3 года назад
GOD bless you. 👏👏👏
@Innozant
@Innozant 3 года назад
Thanks Javed sahab
@TheSuvankarKundu
@TheSuvankarKundu 3 года назад
Thanks for uploading this video on my birthday.. 😍
@Innozant
@Innozant 3 года назад
Happy Birthday Suvankar ji..God bless you dear❤️🙏
@TheSuvankarKundu
@TheSuvankarKundu 3 года назад
@@Innozant thank you so much sir.. Means lot to me.. 🙏🙏
@eighttech
@eighttech 5 месяцев назад
Thanks 🙏
@deepraazshaw7369
@deepraazshaw7369 3 года назад
Thanks you sir for this video
@Innozant
@Innozant 3 года назад
Thanks Deepraz ..gn
@ssalmanhome5287
@ssalmanhome5287 Год назад
Awesome
@rakeshmlearningentertainme6099
@rakeshmlearningentertainme6099 2 года назад
good job sir
@mohammadaijaz4901
@mohammadaijaz4901 3 года назад
Superb! Sir
@Innozant
@Innozant 3 года назад
Thanks Aijaz
@salenakabobby-flowermen
@salenakabobby-flowermen 2 года назад
Boath brilliant bhai. Sukria.
@Innozant
@Innozant 2 года назад
Thanks dear..God bless you
@gold8472685
@gold8472685 2 года назад
Gr8
@ask_puranik
@ask_puranik 3 года назад
Super, First comment 🔥
@Innozant
@Innozant 3 года назад
Thanks dear❤️🙏
@saurabh17sharma68
@saurabh17sharma68 3 года назад
1st view awesome sir
@Innozant
@Innozant 3 года назад
Thanks dear..❤️🙏
@meditationmusic6482
@meditationmusic6482 3 года назад
So nice Sir
@Innozant
@Innozant 3 года назад
Thanks
@alpeshraymane3861
@alpeshraymane3861 3 года назад
very nice ❤️
@Innozant
@Innozant 3 года назад
Thanks Alpesh🙏❤️
@nahidsaiyed8147
@nahidsaiyed8147 2 года назад
Superb
@Innozant
@Innozant 2 года назад
Thanks Dear
@RahulRoy-po9ct
@RahulRoy-po9ct Год назад
SIR 🙏
@satishojha6240
@satishojha6240 3 года назад
Very useful video sir🙏🙏🙏 good night.
@Innozant
@Innozant 3 года назад
Thanks Satish..ye video jaroor learn karen..very important merge method explained.
@satishojha6240
@satishojha6240 3 года назад
@@Innozant of course I always learn your video and at present time my excel level improve day by day 🙏🙏. Thanku sir
@A-R-V
@A-R-V 3 года назад
Kya baat
@Innozant
@Innozant 3 года назад
Thanks 🙏❤️👍
@sonukumar-xp5sd
@sonukumar-xp5sd 2 года назад
Waaw
@Innozant
@Innozant 2 года назад
Thanks
@gauravbhatia7987
@gauravbhatia7987 3 года назад
🙏🙏🙏🙏
@sunilkumar-ds7ho
@sunilkumar-ds7ho 9 месяцев назад
Sir excel 2003 work book ka data se data import ho sakta hai ky excel 2019 me... power query me... Pls reply...
@rajinders64
@rajinders64 Год назад
Sir Power Bi Complete tutorial beginner to expert waiting
@Innozant
@Innozant Год назад
Okay sure
@googleofstudyandmasti2901
@googleofstudyandmasti2901 6 месяцев назад
Sir, if I have made a pivot table on the basis of multiple sheets and now I want to update I can update easily but I want to add new sheet to my appended query so how can I do this?
@mayurt4628
@mayurt4628 11 месяцев назад
For training
@aqeelahmadengr3
@aqeelahmadengr3 3 года назад
Like
@Innozant
@Innozant 3 года назад
❤️🙏
@khalidmajeed2886
@khalidmajeed2886 3 года назад
SIR I AM IN THE LIST OF YOUR LOVER.
@Innozant
@Innozant 3 года назад
Thanks Khalid Sahab❤️❤️🙏
@mmspayal100
@mmspayal100 3 года назад
Dear Sir How join two text columns direct in pivot table..
@Innozant
@Innozant 3 года назад
Using pivot or power ? U r asking
@utkarshmishra8128
@utkarshmishra8128 10 месяцев назад
Sir ek chiz Or agar ek hi table se mujhe 2 column merge karane ho to phir kya karenge?
@jupitermkk
@jupitermkk 3 года назад
Dislike karne वाले वही लोग होते होंगे जिनका दिल हॉस्पिटल मे doctor उनके पैदा होते समय निकाल लेते होंगे। 😍👍
@Innozant
@Innozant 3 года назад
Hahahaha.. Lovely..👍❤️aaye honge kuch fun dekhne yahan mil gya padhne ko to dislike to krenge na Manish ji😂 Thanks for your Concern dear❤️❤️🙏❤️
@konkankid5401
@konkankid5401 3 года назад
Call center ka dashboard share kar sakte ho kya ap muze agar old apke pass rahega to bhi chalega and aht , shrinkege , attrition ke formula bhi plz.
@Innozant
@Innozant 3 года назад
Will.make video for the same.
@konkankid5401
@konkankid5401 3 года назад
@@Innozant ❤️
@mayurt4628
@mayurt4628 11 месяцев назад
How to get in touch with you
@Innozant
@Innozant 11 месяцев назад
You may connect us via @innozantofficial telegram id
@mayurt4628
@mayurt4628 11 месяцев назад
@@Innozant I have messaged on telegram
@iswarrao6858
@iswarrao6858 3 месяца назад
Sir merge query karne ke baad figure double kyo aa rha hai
@umaghosh1282
@umaghosh1282 Год назад
Sir, I am unable to understand the sequence or serial no. Of videos, as u didn't provide series no for ur videos. Plz help me in this regard as I want to watch and learn step by step
@debdeepbhowmick7107
@debdeepbhowmick7107 Год назад
Just Go for all playlists one by one, all videos are in sequences. This is the best tutorial from beginner to advanced level.
@Innozant
@Innozant Год назад
Watch playlist career guide -Mis learning process video is there..Follow that sequence or ..videos in sequence available in video description or in channel playlist
@Innozant
@Innozant Год назад
👍♥️
@mayurt4628
@mayurt4628 11 месяцев назад
How toget in touch with you
@Innozant
@Innozant 11 месяцев назад
You may call us for more details
@mayurt4628
@mayurt4628 11 месяцев назад
Ok .. please advise how to reach
@mayurt4628
@mayurt4628 11 месяцев назад
I have messaged on telegram
@manishanandeshwar8616
@manishanandeshwar8616 Год назад
SIR APKA NO. MIL SAKTA HAI KYA
@Innozant
@Innozant Год назад
Hi Manisha yadi excel related query hai to aap @innozantofficial telegram id par connect kriye ,Course related query hai to Innozant website visit kriye ya call krke detail le sakte hain
@dishupal9443
@dishupal9443 Год назад
Sir power query me merge query me join kind ka options nhi aa ra please help me sir.
@Innozant
@Innozant Год назад
Excel version ?
@dishupal9443
@dishupal9443 Год назад
2016