Merge Tables Using Power Query | Vlookup Alternative

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.c...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
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/innozanti...
#mergerpowerquery#powerquery#innozant #powerquerystepbystep

[@Maunknow]

I want to thank u sir because I joined the institution but they didn't teach well because of ur channel i am learning power queries Thank you so much i am older to bless u but i always remember u in my prayer.god always with you sir

[@Innozant]

Really means a lot to me.Keep learning

[@Altaf_Alam]

Wahh sir ji ... Bahot accha alternative h ye vlookup ka with connection establishment 😊❤

[@huzaifahshah3841]

Kamal sir buhat acha concept clear kia ❤🎉

[@ayazakhtar42]

You are really genius, the way of teaching and explaining is really splendid . I have learnt lot of from your videos.

[@Innozant]

Thanks Ayaz

[@82asm]

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]

Thanks Asim Sahab for your valuable appreciation..Haan Air videos aayeng power Query ke

[@princekamboj1620]

one of the best channels on youtube for learning. Thanks a ton sir .

[@ArifRashid786]

choty bhai ji chah raha hau chumi lay loon tumhari... boeht acha samjhaya.... shukarya

[@VipulJain40]

wahh Guruji .. Tussi Great ho .. Kab se dhund raha tha ye content

[@Innozant]

Thanks Viul👍

[@jyotiprasadchaudhary8527]

Wow......I have learned. Credit goes to u brother.

[@Innozant]

Thanks Jyoti.Keep learning 👍❤️

[@SujonKhan-c4o]

Thank you so much for every videos

[@devangthakkar6847]

Dear Sir, Superb Power query tutorial. Thanks for updates.

[@Innozant]

Thanks Devang sahab

[@ArmaanKing17]

Thank you so much sir for making difficult concepts interesting 😊

[@Innozant]

Keep learning

[@pravinkumbhare1750]

🎉 concept clear ho Gaya sir, thanks..

[@heeralalkumawat2132]

Sir🎉❤❤❤❤ Ye video mere bhut kaam aayega

[@Innozant]

Thanks

[@hemantsharma4896]

fantastic Videos 🙏🙏🙏

[@pramodbhavsar4488]

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]

Thanks Pramod Ji..Hope you like and learn from this

[@jayantabhattacharyya628]

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]

Thanks Jayanta for your appreciation..God bless you..Happg Learning dear

[@satishojha6240]

Very useful video sir🙏🙏🙏 good night.

[@Innozant]

Thanks Satish..ye video jaroor learn karen..very important merge method explained.

[@satishojha6240]

@@Innozant of course I always learn your video and at present time my excel level improve day by day 🙏🙏. Thanku sir

[@acommonman155]

Nice & Easy Explanation GURU JI 🙏

[@helendroza3833]

You teach so well 🙏🏻

[@Innozant]

Thanks dear

[@TheSuvankarKundu]

Thanks for uploading this video on my birthday.. 😍

[@Innozant]

Happy Birthday Suvankar ji..God bless you dear❤️🙏

[@TheSuvankarKundu]

@@Innozant thank you so much sir.. Means lot to me.. 🙏🙏

[@avinashverma52]

Great and very easy explanation .

[@Innozant]

Thanks Avinash Ji

[@iamsainipawan]

Sir merge query is most powerful tool rather then vloookup or index match clearly understand concept of merge query 🙏🙏🙏

[@rakeshmlearningentertainme6099]

good job sir

[@rockfighter9974]

Really nice video

[@ExcelZone]

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]

Thanks Surender ji

[@kishorpanara4191]

Maza aa gaya sir your work excellent thanks sir

[@Innozant]

Thanks Kishor..❤️🙏

[@salenakabobby-flowermen]

Boath brilliant bhai. Sukria.

[@Innozant]

Thanks dear..God bless you

[@mjaved701]

GOD bless you. 👏👏👏

[@Innozant]

Thanks Javed sahab

[@AnkitMishra-so5qo]

Thank you 🎉

[@mohammadaijaz4901]

Superb! Sir

[@Innozant]

Thanks Aijaz

[@ask_puranik]

Super, First comment 🔥

[@Innozant]

Thanks dear❤️🙏

[@SAJJADAHMAD-uy3hu]

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.

[@jupitermkk]

Dislike karne वाले वही लोग होते होंगे जिनका दिल हॉस्पिटल मे doctor उनके पैदा होते समय निकाल लेते होंगे। 😍👍

[@Innozant]

Hahahaha.. Lovely..👍❤️aaye honge kuch fun dekhne yahan mil gya padhne ko to dislike to krenge na Manish ji😂 Thanks for your Concern dear❤️❤️🙏❤️

[@foziasharifmalik6657]

Great

[@meditationmusic6482]

So nice Sir

[@Innozant]

Thanks

[@shrikantbadge3978]

Amazing thank u sir

[@navnathborade]

Nice and thank

[@nahidsaiyed8147]

Superb

[@Innozant]

Thanks Dear

[@eighttech]

Thanks 🙏

[@alpeshraymane3861]

very nice ❤️

[@Innozant]

Thanks Alpesh🙏❤️

[@deepraazshaw7369]

Thanks you sir for this video

[@Innozant]

Thanks Deepraz ..gn

[@googleofstudyandmasti2901]

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?

[@sunilkumar-ds7ho]

Sir excel 2003 work book ka data se data import ho sakta hai ky excel 2019 me... power query me... Pls reply...

[@ssalmanhome5287]

Awesome

[@saurabh17sharma68]

1st view awesome sir

[@Innozant]

Thanks dear..❤️🙏

[@abhinav10x]

Thank you

[@utkarshmishra8128]

Sir ek chiz Or agar ek hi table se mujhe 2 column merge karane ho to phir kya karenge?

[@gold8472685]

Gr8

[@interact-yugal]

one to many to relationships ka v example karaiye Parent table - Invoice table Child tables - Customer table - 1 to 1 relationship Item transactions table - 1 to many relationship Ledger transactions / journal table - 1 to many relationship Inke combination se, ek final invoice report banega

[@rajinders64]

Sir Power Bi Complete tutorial beginner to expert waiting

[@Innozant]

Okay sure

[@konkankid5401]

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]

Will.make video for the same.

[@konkankid5401]

@@Innozant ❤️

[@mmspayal100]

Dear Sir How join two text columns direct in pivot table..

[@Innozant]

Using pivot or power ? U r asking

[@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]

Just Go for all playlists one by one, all videos are in sequences. This is the best tutorial from beginner to advanced level.

[@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]

👍♥️

[@iswarrao6858]

Sir merge query karne ke baad figure double kyo aa rha hai

[@RahulRoy-po9ct]

SIR 🙏

[@gauravbhatia7987]

🙏🙏🙏🙏

[@dishupal9443]

Sir power query me merge query me join kind ka options nhi aa ra please help me sir.

[@Innozant]

Excel version ?

[@dishupal9443]

2016

[@mayurt4628]

How to get in touch with you

[@Innozant]

You may connect us via @innozantofficial telegram id

[@mayurt4628]

@@Innozant I have messaged on telegram

[@A-R-V]

Kya baat

[@Innozant]

Thanks 🙏❤️👍

[@khalidmajeed2886]

SIR I AM IN THE LIST OF YOUR LOVER.

[@Innozant]

Thanks Khalid Sahab❤️❤️🙏

[@mayurt4628]

How toget in touch with you

[@Innozant]

You may call us for more details

[@mayurt4628]

Ok .. please advise how to reach

[@mayurt4628]

I have messaged on telegram

[@mayurt4628]

For training

[@sonukumar-xp5sd]

Waaw

[@Innozant]

Thanks

[@manishanandeshwar8616]

SIR APKA NO. MIL SAKTA HAI KYA

[@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

[@aqeelahmadengr3]

Like

[@Innozant]

❤️🙏