Excel मे data merge करने का आसान तरीका। Merge excel table using Excel Power query

  Рет қаралды 83,117

Excel Tutorial

Excel Tutorial

2 жыл бұрын

Excel मे data merge करने का आसान तरीका। Merge excel table using Excel power query.
To Dosto, Aaj ke is video mai me aapko sikhane wala hu excel me data merge karne ka aasan aur smart tarika. jise sikhkar aap bade se bade data ko Excel powerquery ki madat se merge kar sakte ho. To chaliye ye video pura dekhiye aur iski practice karna mat bhulna. Jaroor comment section batana ki ye video aapko kaisa laga.
#ExcelPowerQuery
#ExcelTutorial
To Download 📁practice files join our telegram channel :t.me/learnmoreindia
Online Video Courses sikhna Matalab 1) Samay Bachana 2) Paise Bachana 3) Advance Chije Sikhana 4) Sabse Important Khud se sikhane ki aadat Dalana sab to fayde me hai fir Q na aap check kare Humari website: www.coursepe.com/
--------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Courses Website :bit.ly/skill_course
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇️ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : skillcourse.in/
---------------------------------------------------------------------------------------------------------------------------
To download the practice file visit our telegram channel: telegram.me/learnmoreindia
Check our latest blogs: learnmoreindia.in/
---------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
---------------------------------------------------------------------------------------------------------------------------
My Other Channels:
Real Tutorial: ✅
/ @realtutorial550
Complete Technology:✅
/ @completetechnology
Learn more shorts:✅
/ @learnmoreshorts
Satish Tech (Marathi):✅
/ @satish_tech
Tally Tutorial:✅
/ @tallytutorial
Excel Tutorial:✅
/ @excel_tutorial
Learn More:✅
/ @learn_more
Curiosity: ✅
/ @curiosity9432
---------------------------------------------------------------------------------------------------------------------------
My KZbin Gears :
Best Mic for Recording (Condenser Mic): amzn.to/2UUMDnH
Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
My DSLR Camera Canon 200D: amzn.to/39ciw3E
My Laptop (Video Editing): amzn.to/2UXQj8h
Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
Antivirus: amzn.to/3l3TIgi
Screen Recording Software: bit.ly/2J39n2j
Video Editing Software: bit.ly/3nOPlri
Green screen with Stand: amzn.to/2KAl1Cu

Пікірлер: 105
@Excel_Tutorial
@Excel_Tutorial Жыл бұрын
Learn Satish Sir courses with Certificate Download Course App : bit.ly/3BWfQVa Courses Website :bit.ly/skill_course ✅ Watch on Desktop : skillcourse.in/
@hemrajswarnkar9734
@hemrajswarnkar9734 7 ай бұрын
very helpful video sir
@mohammadwasiuddin6579
@mohammadwasiuddin6579 11 ай бұрын
Fantastic really appreciate your way of teaching - Thanks
@darashyambabu6113
@darashyambabu6113 6 ай бұрын
Good evening sir marvelous teaching very useful tips sir thank you sir
@karimsamnani3660
@karimsamnani3660 Жыл бұрын
Very nice explain Power Query - Merge table & combine data
@TVSCDN
@TVSCDN Жыл бұрын
Thanks a lot sir🎉🎉❤
@sangampihwal0412
@sangampihwal0412 Жыл бұрын
Hello sir I am SANGAM PIHWAL Yours online student Sir aisa mere sath Bhout bar hota hai Aisa hota hi rehta h M Kal se Yeh Sikhna chahta tha Iske liye Apka very very very very thanks to you for this
@jitendrabomble2218
@jitendrabomble2218 2 жыл бұрын
Thanks sir. Very useful information.
@prakashvyas3244
@prakashvyas3244 Жыл бұрын
Well explained Sir Thank you
@Altaf_Alam
@Altaf_Alam Жыл бұрын
Thank u so much sir for make this knowledgeable video🔥❤️
@drprabhakarbhagwat
@drprabhakarbhagwat 2 жыл бұрын
Superb power query 🙏👌👌
@AjitKumar-pt9jb
@AjitKumar-pt9jb Жыл бұрын
Very fruitful video sir 👍
@sunilkumarverma4268
@sunilkumarverma4268 9 ай бұрын
Super Thanks for your valuable video
@prabhakarpawar573
@prabhakarpawar573 2 жыл бұрын
Very usefull sirji
@azzu2294
@azzu2294 2 жыл бұрын
Tq so much sir for this wonderful video
@lekhrajbairwa228
@lekhrajbairwa228 11 ай бұрын
"Engaging and insightful teaching on a fascinating topic!"
@canirmalchoudhary8173
@canirmalchoudhary8173 Жыл бұрын
Amazing 👏
@ShivamKatheriya-yz6wf
@ShivamKatheriya-yz6wf Жыл бұрын
It's very interesting video of excel
@arunkumarsinghark3024
@arunkumarsinghark3024 2 жыл бұрын
बहुत बहुत धन्यावाद
@sandeepsirohi1437
@sandeepsirohi1437 Жыл бұрын
आपका पढाने का तरिका बहुत अच्छा है सर
@SaurabhSharma-ry8iz
@SaurabhSharma-ry8iz Жыл бұрын
Very informative video sir
@shashikantchaudhari1378
@shashikantchaudhari1378 Жыл бұрын
Excellent 👌 Sir 💐💐
@lucky-pm2pe
@lucky-pm2pe 10 ай бұрын
Excellent video sir
@sanjeevpavadad7634
@sanjeevpavadad7634 2 жыл бұрын
Arrey wow... You have done very nice tricks.. Thank you sir... Anv Happy Guru Purnima Sir
@vikashgangwal9054
@vikashgangwal9054 2 жыл бұрын
sar wherhouse m use hony waly sap ki bhi classes start Karo please
@gautamkadam9131
@gautamkadam9131 Жыл бұрын
Acha explain kiya
@bijaytanty8434
@bijaytanty8434 Жыл бұрын
Thanks Sir👍
@aasifkhaniqbalkhan4108
@aasifkhaniqbalkhan4108 8 ай бұрын
excellent
@hensonvanyvlogs12
@hensonvanyvlogs12 Жыл бұрын
thank you sir I am working as a data analytics
@gorakhkhatele7238
@gorakhkhatele7238 Жыл бұрын
Very good sir
@hariomsingh-en9ps
@hariomsingh-en9ps Жыл бұрын
Super sir
@arunkumarsinghark3024
@arunkumarsinghark3024 2 жыл бұрын
🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
@santoshmarkam4412
@santoshmarkam4412 2 жыл бұрын
Nice sir good
@manmohangawali3094
@manmohangawali3094 Жыл бұрын
Thank you sir
@Deepakkumar-ne1jq
@Deepakkumar-ne1jq Жыл бұрын
Very interesting
@nainaverma8673
@nainaverma8673 7 ай бұрын
👌👌
@cagautamkumar8211
@cagautamkumar8211 11 ай бұрын
Very good
@syedyousuf3531
@syedyousuf3531 6 ай бұрын
Excellent teaching method
@Excel_Tutorial
@Excel_Tutorial 9 күн бұрын
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzbin.info/www/bejne/m5DPk2N8eKaNaJY)
@SUNILMAURYA-ju8iu
@SUNILMAURYA-ju8iu Жыл бұрын
Nice sir
@sanjeevsharma2306
@sanjeevsharma2306 3 ай бұрын
Thanks
@rajeevvyas4854
@rajeevvyas4854 Ай бұрын
Thank
@mr.x3453
@mr.x3453 Жыл бұрын
sir make a videos series on power BI and dashboard....... Plz sir...........you teach much better than other and i understand each and every thing fast and remember for long period of time.......... Plz sir pick my comment ..................
@naziriqbal3980
@naziriqbal3980 Жыл бұрын
good yar
@anandravi1498
@anandravi1498 6 ай бұрын
Thanks for the update
@Excel_Tutorial
@Excel_Tutorial 9 күн бұрын
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzbin.info/www/bejne/m5DPk2N8eKaNaJY)
@arunkumarsinghark3024
@arunkumarsinghark3024 2 жыл бұрын
शुक्रिया सर जी धन्यवाद् 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
@judaysinghsidar8216
@judaysinghsidar8216 Жыл бұрын
Super
@techsolutions533
@techsolutions533 2 жыл бұрын
nice
@Mylifestoryofvicky
@Mylifestoryofvicky Жыл бұрын
Good evening sir
@amanarman2113
@amanarman2113 Жыл бұрын
🙏🙏🙏
@EVFinserv
@EVFinserv 2 күн бұрын
Hi Sir, this trick works for me, but i want to use that same workbook with multiple users simultaneously.. when i click to in the review tab to share workbook that shows me an error that "This can not be create because it contains excel table or xml maps.
@anuskitchen4367
@anuskitchen4367 2 жыл бұрын
Sir please SAP course cha vdo bnva please
@utsavmaidankar
@utsavmaidankar 6 ай бұрын
Hi, Can you please make a video to combine multiple workbook into one workbook. Note: Each workbook contain multiple worksheet
@rajeshpatil8885
@rajeshpatil8885 Жыл бұрын
Hello i recorded macro for one row and i want to repeat that macro to other row in same excel sheet can you please tell me how to do that
@manojrock4428
@manojrock4428 Жыл бұрын
Time table Routine bana kar dikhaye Lagbhag 10 batch 5 faculty Automatic hona chahiye Faculty by
@spacex4496
@spacex4496 11 ай бұрын
excellent video sir but how can i know that the updated data is from Sanjay Singh. I mean can we add an automate column contains user name
@Prince19945
@Prince19945 2 жыл бұрын
Sir agar mai all course buy krta hu to isme aapne jitne bhi description me course de rakhi hai wo sab aati hai kya, please reply 🙏🙏
@scacademy9680
@scacademy9680 Жыл бұрын
When I add multiple worksheet values in one worksheet using consolidate tool we get the result but changing data in sheet 1 or sheet 2 the result not changed. Plz solve it
@sunitachauhan7386
@sunitachauhan7386 9 ай бұрын
Please suggest sir 🙏🙏
@khalidmajeed2886
@khalidmajeed2886 Жыл бұрын
sir bohat saraay table hoo to un kko aik sath keesay table maay convert karaay gaay
@sanjeetsharma2700
@sanjeetsharma2700 2 жыл бұрын
Sir define name tab ka video banaiye
@sanjeevverma927
@sanjeevverma927 2 жыл бұрын
Ye video dekhiye problem solve ho jayegi-kzbin.info/www/bejne/sJu0f5yPnLKhqqs
@warishawarisha870
@warishawarisha870 10 ай бұрын
Sir aap konsa excel use krte h ?
@krishnanandankumar
@krishnanandankumar 8 ай бұрын
Bhai mera table ka top row colomn me hai aur 28 sheets hai to power query me aisa option hai jo heads ko transpose kerk row m heading aa jaye
@kundanlal4133
@kundanlal4133 9 ай бұрын
Can do it from editor and select source.. we don't need to create any link.. please confirm ??
@arunraj2.052
@arunraj2.052 Жыл бұрын
Sir ji office 2010 64bit provide kar dijiye please
@manjit.sarania
@manjit.sarania Жыл бұрын
I would like to buy power query and vba code course
@sanjeetsharma2700
@sanjeetsharma2700 2 жыл бұрын
Sir please
@Sunilsingh-xm7lz
@Sunilsingh-xm7lz 8 ай бұрын
How to merge horizontaly
@user-nl5dm4dq1h
@user-nl5dm4dq1h 6 ай бұрын
Hello Sir, We have a folder in which we have 150 no. of excel files & all these files data is being stored in a different master file using get data from folder option. Each time when we are changing the data in these files same thing is updating in master file. It is simply over writing the same. Is there any option so that we can add on the change instead of overwriting.
@sunitachauhan7386
@sunitachauhan7386 9 ай бұрын
Dashboard Kaise banaye
@kishantripathi322
@kishantripathi322 2 жыл бұрын
Satish sir Mere pc ke ms Word ke document mein sirf 3 side border print ho rha hai satish sir iska solution bataiye
@sanjeevverma927
@sanjeevverma927 2 жыл бұрын
Ye video dekhiye problem solve ho jayegi - kzbin.info/www/bejne/gonTlo2omqljbJo
@neharajput568
@neharajput568 8 ай бұрын
hloo sir help me please. Phle mere excel me power query me same yhi hota tha.. connection only but I don't how? Ab row,label likha aata h..jisse wo merge nhi hora..two sheets alag alag hi aari h..plz aap bta skte h power query ki setting kha se khrab hui h or thik kese hogi.. mujhe oski zrorat h sir..plzzzz
@akbarwarsi7327
@akbarwarsi7327 11 ай бұрын
Sir agar koi nayi sheet add huwa to wo kaise update hoga please..
@arunkumarsinghark3024
@arunkumarsinghark3024 Жыл бұрын
Sir, किसी workbook के कुछ columns के data को किसी another workbook के किसी specified sheet me कैसे automatically copy कर सकते हैं, Please macro, vba या कोई formula सिखाइए,मुझे रोज mis report मिलता है जिसके कुछ columns बने बनाए एक excel format मे copy paste रोज करना पड़ता है, please इसे automatically copy mode par लाना चाहते हैं, macro, vba या कोई formula सिखाइए please 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
@excelonlineadvisor
@excelonlineadvisor Жыл бұрын
Macro m aap 1 command record kr lijiye, old file se data copy kr k and new file m paste krne ka.
@siddharthsaran4437
@siddharthsaran4437 11 ай бұрын
Sir Append Queries m Append queries as a new wala option ni aa Raha hai Mere pass MS Excel 2016 hai. Please tell me what should I do..
@susilasamal6754
@susilasamal6754 6 ай бұрын
If the heading is different how we merge it.
@nitinverma5842
@nitinverma5842 2 жыл бұрын
Sir ye excel 2007 main kaam karega
@Excel_Tutorial
@Excel_Tutorial 2 жыл бұрын
Nahi ye 2010 ke aage wale office me chalega.
@user-mn8xq7mv6j
@user-mn8xq7mv6j Жыл бұрын
Sir, Append Queries as new ka option nahi aa raha please help me
@sundarram763
@sundarram763 Жыл бұрын
How to convert pdf to excell in easy way
@mr.x3453
@mr.x3453 Жыл бұрын
sir try to give source code link with gmail.......... I can't use source code from telegram.....
@Mylifestoryofvicky
@Mylifestoryofvicky Жыл бұрын
Mera Excel 2016 hai magar Esme power query option 1 or 2 hai usme se first chal raha hai magar second nhi unable ho raha hai
@excelonlineadvisor
@excelonlineadvisor Жыл бұрын
Upgrade your excel, bht sare links h Internet p, wha se aap upgraded version download kr skte o
@vikrampandey2349
@vikrampandey2349 2 жыл бұрын
Hi sir, Maine aapka Excel VBA course buy Kiya tha or kuchh video bhi maine dekha hai. Lekin uske bad maine ek free course bhi kiya or uska certificate download karne ki koshi kiya par wo download nahi ho raha tha iss liye maine aapke technical team se contact Kiya what's app par uske bad aapke team ke taraf se mera password change kar diya or main abhi login nahi kar pa raha hu. Please help me to recover my password.
@Excel_Tutorial
@Excel_Tutorial 2 жыл бұрын
Sure our team will call you
@vikrampandey2349
@vikrampandey2349 2 жыл бұрын
@@Excel_Tutorial thankyou. your team contact me and resolve the issue.
@im_suraz
@im_suraz Жыл бұрын
practice file download nahi horaha hai
@vijayuikey311
@vijayuikey311 Жыл бұрын
Sir please datasets ka link telegram me share na karein yahi par karein.
@ejanghanse4661
@ejanghanse4661 Жыл бұрын
Website ka name Kya hai
@arunkumarsinghark3024
@arunkumarsinghark3024 Жыл бұрын
Sir, मेरी excel file में लगभग दो लाख lines है जिसमें functions भी है, वह file use करने पर पूरी hang हो जाती है, कोई उपाय बताए सर please, बहुत परेसान हूँ, ऑफिस में It टीम भी solution नहीं दे pa रही please please please सर, कृपया मार्गदर्शन करे l मुझे आपकी इस समय बहुत जरूरत है सर l 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
@Mjgaud20
@Mjgaud20 Жыл бұрын
Excel ki jagah panda 🐼 pe work kro
@pankajknowledgeworld
@pankajknowledgeworld Жыл бұрын
मे सतीश आपका स्वागत कर्ता हू.. लाओ चाय sandwich 🥪 लाई जाए स्वागत अच्छे से करो
@RohitRawat-jo1tw
@RohitRawat-jo1tw Жыл бұрын
Consolidate se bhi ho jayegi kya sir
@RohitRawat-jo1tw
@RohitRawat-jo1tw Жыл бұрын
Pls sir rply
@gaonkikheti7363
@gaonkikheti7363 6 ай бұрын
Ads are so irritating 😔😔😔
@RohitKumar-cc7zi
@RohitKumar-cc7zi Жыл бұрын
Your way of Teaching is😌 very confusing
@abdulghaffarasi6649
@abdulghaffarasi6649 Жыл бұрын
Hello i am from Pakistan. i found your page very helpful to learn excel formulas. i need a little favor to complete my sheet auto fill some rates that i have to repeatedly write down. i dont see any option to link my file here, how can i tell you the problem...? Give me your email ID or any contact number where i can upload my file to make changes.
@mdsani743
@mdsani743 Жыл бұрын
Thanks sir
@arunkumarsinghark3024
@arunkumarsinghark3024 Жыл бұрын
🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
@vijayuikey311
@vijayuikey311 Жыл бұрын
Sir please datasets ka link telegram me share na karein yahi par karein.
Wow😲! Epic trick of Excel to combine data from multiple excel files.
23:47
I CAN’T BELIEVE I LOST 😱
00:46
Topper Guild
Рет қаралды 79 МЛН
КАРМАНЧИК 2 СЕЗОН 7 СЕРИЯ ФИНАЛ
21:37
Inter Production
Рет қаралды 463 М.
버블티로 체감되는 요즘 물가
00:16
진영민yeongmin
Рет қаралды 96 МЛН
1 or 2?🐄
00:12
Kan Andrey
Рет қаралды 32 МЛН
How to Use Filter Smartly in Excel | Excel Tips & Tricks
0:55
Abhijeetji Technical 4M
Рет қаралды 1,2 МЛН
Learn POWER QUERY step by step in Hindi - Advance Excel
50:02
Merge OR Concatenate two columns in Ms Excel
0:45
Techies 2.O
Рет қаралды 403 М.
Excel useful formula Series in Hindi - Part-1
18:03
Excel Tutorial
Рет қаралды 377 М.
Vlookup Formula Hacks | Advance Excel Tips & Tricks
1:00
Gyani Abhijeetji
Рет қаралды 672 М.
PMT | IPMT | PPMT | PV | Excel Financial Formulas in Hindi #excel
10:34
Import Data From Web in Excel | Easy Excel
1:04
sirblue-digital
Рет қаралды 213
I CAN’T BELIEVE I LOST 😱
00:46
Topper Guild
Рет қаралды 79 МЛН