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

Поделиться
HTML-код
  • Опубликовано: 15 окт 2024
  • 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/learnmore...
    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_c...
    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/le...
    Check our latest blogs: learnmoreindia...
    ---------------------------------------------------------------------------------------------------------------------------
    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 RUclips 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

Комментарии • 112

  • @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/

  • @darashyambabu6113
    @darashyambabu6113 9 месяцев назад

    Good evening sir
    marvelous teaching very useful tips sir thank you sir

  • @sangampihwal0412
    @sangampihwal0412 2 года назад +1

    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

  • @karimsamnani3660
    @karimsamnani3660 2 года назад

    Very nice explain Power Query - Merge table & combine data

  • @mohammadwasiuddin6579
    @mohammadwasiuddin6579 Год назад +1

    Fantastic really appreciate your way of teaching - Thanks

  • @sunilkumarverma4268
    @sunilkumarverma4268 Год назад

    Super
    Thanks for your valuable video

  • @hemrajswarnkar9734
    @hemrajswarnkar9734 11 месяцев назад +1

    very helpful video sir

  • @ShivamKatheriya-yz6wf
    @ShivamKatheriya-yz6wf 2 года назад

    It's very interesting video of excel

  • @sanjeevpavadad7634
    @sanjeevpavadad7634 2 года назад

    Arrey wow... You have done very nice tricks.. Thank you sir... Anv Happy Guru Purnima Sir

  • @TVSCDN
    @TVSCDN Год назад +1

    Thanks a lot sir🎉🎉❤

  • @hensonvanyvlogs12
    @hensonvanyvlogs12 Год назад

    thank you sir I am working as a data analytics

  • @syedyousuf3531
    @syedyousuf3531 9 месяцев назад

    Excellent teaching method

    • @Excel_Tutorial
      @Excel_Tutorial  3 месяца назад

      Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ruclips.net/video/e_lb0FCAZ24/видео.html)

  • @lucky-pm2pe
    @lucky-pm2pe Год назад

    Excellent video sir

  • @SaurabhSharma-ry8iz
    @SaurabhSharma-ry8iz Год назад

    Very informative video sir

  • @kamalsahu3324
    @kamalsahu3324 3 месяца назад +1

    Fantastic 😍

  • @Altaf_Alam
    @Altaf_Alam 2 года назад +2

    Thank u so much sir for make this knowledgeable video🔥❤️

  • @lekhrajbairwa228
    @lekhrajbairwa228 Год назад

    "Engaging and insightful teaching on a fascinating topic!"

  • @user-cx1tx8qd3b
    @user-cx1tx8qd3b 24 дня назад

    Good information

    • @Excel_Tutorial
      @Excel_Tutorial  22 дня назад

      Many many thanks 😊😊😊😊😊😊

  • @sandeepsirohi1437
    @sandeepsirohi1437 2 года назад

    आपका पढाने का तरिका बहुत अच्छा है सर

  • @mr.x3453
    @mr.x3453 2 года назад

    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 ..................

  • @gautamkadam9131
    @gautamkadam9131 Год назад

    Acha explain kiya

  • @jitendrabomble2218
    @jitendrabomble2218 2 года назад

    Thanks sir.
    Very useful information.

  • @SUNILMAURYA-ju8iu
    @SUNILMAURYA-ju8iu Год назад

    Nice sir

  • @bijaykumarmishra7689
    @bijaykumarmishra7689 13 дней назад

    Mind blowing tips but can we do the same thing fora bank statement consisting 92 sheets

  • @drprabhakarbhagwat
    @drprabhakarbhagwat 2 года назад

    Superb power query 🙏👌👌

  • @arunkumarsinghark3024
    @arunkumarsinghark3024 2 года назад +1

    🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l

  • @hariomsingh-en9ps
    @hariomsingh-en9ps 2 года назад +1

    Super sir

  • @arunkumarsinghark3024
    @arunkumarsinghark3024 2 года назад +1

    बहुत बहुत धन्यावाद

  • @vikashgangwal9054
    @vikashgangwal9054 2 года назад +3

    sar wherhouse m use hony waly sap ki bhi classes start Karo please

  • @judaysinghsidar8216
    @judaysinghsidar8216 2 года назад

    Super

  • @Deepakkumar-ne1jq
    @Deepakkumar-ne1jq 2 года назад

    Very interesting

  • @shashikantchaudhari1378
    @shashikantchaudhari1378 2 года назад

    Excellent 👌 Sir 💐💐

  • @sabitrikc3047
    @sabitrikc3047 2 месяца назад

    Thanks kind information

  • @gorakhkhatele7238
    @gorakhkhatele7238 2 года назад

    Very good sir

  • @naziriqbal3980
    @naziriqbal3980 2 года назад

    good yar

  • @AjitKumar-pt9jb
    @AjitKumar-pt9jb 2 года назад

    Very fruitful video sir 👍

  • @anandravi1498
    @anandravi1498 9 месяцев назад

    Thanks for the update

    • @Excel_Tutorial
      @Excel_Tutorial  3 месяца назад

      Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ruclips.net/video/e_lb0FCAZ24/видео.html)

  • @EVFinserv
    @EVFinserv 3 месяца назад

    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.

  • @prabhakarpawar573
    @prabhakarpawar573 2 года назад

    Very usefull sirji

  • @azzu2294
    @azzu2294 2 года назад

    Tq so much sir for this wonderful video

  • @santoshmarkam4412
    @santoshmarkam4412 2 года назад

    Nice sir good

  • @arunkumarsinghark3024
    @arunkumarsinghark3024 2 года назад

    शुक्रिया सर जी धन्यवाद् 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l

  • @Vibhujitiwari
    @Vibhujitiwari 9 месяцев назад

    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.

  • @sanjeevsharma2306
    @sanjeevsharma2306 6 месяцев назад

    Thanks

  • @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 🙏🙏

  • @kundanlal4133
    @kundanlal4133 Год назад

    Can do it from editor and select source.. we don't need to create any link.. please confirm ??

  • @aasifkhaniqbalkhan4108
    @aasifkhaniqbalkhan4108 11 месяцев назад

    excellent

  • @Mylifestoryofvicky
    @Mylifestoryofvicky 2 года назад

    Good evening sir

  • @warishawarisha870
    @warishawarisha870 Год назад

    Sir aap konsa excel use krte h ?

  • @TilawatQuranPak123
    @TilawatQuranPak123 4 дня назад

    thanks

  • @khalidmajeed2886
    @khalidmajeed2886 Год назад

    sir bohat saraay table hoo to un kko aik sath keesay table maay convert karaay gaay

  • @rajeevvyas4854
    @rajeevvyas4854 4 месяца назад

    Thank

  • @canirmalchoudhary8173
    @canirmalchoudhary8173 2 года назад +1

    Amazing 👏

  • @krishnanandankumar
    @krishnanandankumar 11 месяцев назад

    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

  • @spacex4496
    @spacex4496 Год назад

    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

  • @neharajput568
    @neharajput568 11 месяцев назад

    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

  • @mdsani743
    @mdsani743 2 года назад

    Thanks sir

  • @bijaytanty8434
    @bijaytanty8434 2 года назад

    Thanks Sir👍

  • @utsavmaidankar
    @utsavmaidankar 10 месяцев назад

    Hi, Can you please make a video to combine multiple workbook into one workbook.
    Note: Each workbook contain multiple worksheet

  • @manmohangawali3094
    @manmohangawali3094 2 года назад

    Thank you sir

  • @techsolutions533
    @techsolutions533 2 года назад

    nice

  • @scacademy9680
    @scacademy9680 Год назад +1

    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

  • @siddharthsaran4437
    @siddharthsaran4437 Год назад

    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..

  • @manjit.sarania
    @manjit.sarania 2 года назад

    I would like to buy power query and vba code course

  • @nainaverma8673
    @nainaverma8673 10 месяцев назад

    👌👌

  • @vikrampandey2349
    @vikrampandey2349 2 года назад +1

    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 года назад +1

      Sure our team will call you

    • @vikrampandey2349
      @vikrampandey2349 2 года назад +1

      @@Excel_Tutorial thankyou. your team contact me and resolve the issue.

  • @akbarwarsi7327
    @akbarwarsi7327 Год назад

    Sir agar koi nayi sheet add huwa to wo kaise update hoga please..

  • @sanjeetsharma2700
    @sanjeetsharma2700 2 года назад

    Sir define name tab ka video banaiye

    • @sanjeevverma927
      @sanjeevverma927 2 года назад +1

      Ye video dekhiye problem solve ho jayegi-ruclips.net/video/zjQNiYgMntI/видео.html

  • @rajeshpatil8885
    @rajeshpatil8885 2 года назад

    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

  • @kishantripathi322
    @kishantripathi322 2 года назад +1

    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 - ruclips.net/video/LXpeZreD068/видео.html

  • @manojrock4428
    @manojrock4428 2 года назад

    Time table Routine bana kar dikhaye
    Lagbhag 10 batch
    5 faculty
    Automatic hona chahiye
    Faculty by

  • @arunraj2.052
    @arunraj2.052 2 года назад

    Sir ji office 2010 64bit provide kar dijiye please

  • @Mylifestoryofvicky
    @Mylifestoryofvicky 2 года назад

    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 2 года назад

      Upgrade your excel, bht sare links h Internet p, wha se aap upgraded version download kr skte o

  • @arunkumarsinghark3024
    @arunkumarsinghark3024 2 года назад +1

    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 2 года назад

      Macro m aap 1 command record kr lijiye, old file se data copy kr k and new file m paste krne ka.

  • @nitinverma5842
    @nitinverma5842 2 года назад

    Sir ye excel 2007 main kaam karega

    • @Excel_Tutorial
      @Excel_Tutorial  2 года назад

      Nahi ye 2010 ke aage wale office me chalega.

  • @amanarman2113
    @amanarman2113 2 года назад

    🙏🙏🙏

  • @SunitaChouhan-s6p
    @SunitaChouhan-s6p Год назад

    Sir, Append Queries as new ka option nahi aa raha please help me

  • @yogeshrao5924
    @yogeshrao5924 2 месяца назад

    Confusion Bahut he shreemaan

  • @Sunilsingh-xm7lz
    @Sunilsingh-xm7lz Год назад

    How to merge horizontaly

  • @susilasamal6754
    @susilasamal6754 10 месяцев назад

    If the heading is different how we merge it.

  • @sunitachauhan7386
    @sunitachauhan7386 Год назад

    Please suggest sir 🙏🙏

  • @ejanghanse4661
    @ejanghanse4661 Год назад

    Website ka name Kya hai

  • @arunkumarsinghark3024
    @arunkumarsinghark3024 2 года назад

    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

  • @RohitRawat-jo1tw
    @RohitRawat-jo1tw 2 года назад

    Consolidate se bhi ho jayegi kya sir

  • @sunitachauhan7386
    @sunitachauhan7386 Год назад

    Dashboard Kaise banaye

  • @vijayuikey311
    @vijayuikey311 2 года назад

    Sir please datasets ka link telegram me share na karein yahi par karein.

  • @Official_Suraz
    @Official_Suraz Год назад

    practice file download nahi horaha hai

  • @mr.x3453
    @mr.x3453 2 года назад

    sir try to give source code link with gmail..........
    I can't use source code from telegram.....

  • @sundarram763
    @sundarram763 Год назад

    How to convert pdf to excell in easy way

  • @sanjeetsharma2700
    @sanjeetsharma2700 2 года назад

    Sir please

  • @pankajknowledgeworld
    @pankajknowledgeworld 2 года назад

    मे सतीश आपका स्वागत कर्ता हू.. लाओ चाय sandwich 🥪 लाई जाए स्वागत अच्छे से करो

  • @gaonkikheti7363
    @gaonkikheti7363 10 месяцев назад

    Ads are so irritating 😔😔😔

  • @RohitKumar-cc7zi
    @RohitKumar-cc7zi Год назад

    Your way of Teaching is😌 very confusing

  • @anuskitchen4367
    @anuskitchen4367 2 года назад

    Sir please SAP course cha vdo bnva please

  • @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.

  • @arunkumarsinghark3024
    @arunkumarsinghark3024 2 года назад +1

    🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l

  • @cagautamkumar8211
    @cagautamkumar8211 Год назад

    Very good

  • @prakashvyas3244
    @prakashvyas3244 2 года назад

    Well explained Sir Thank you

  • @vijayuikey311
    @vijayuikey311 2 года назад

    Sir please datasets ka link telegram me share na karein yahi par karein.