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

Поділитися
Вставка
  • Опубліковано 25 січ 2025

КОМЕНТАРІ • 114

  • @Excel_Tutorial
    @Excel_Tutorial  2 роки тому

    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 Рік тому

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

  • @hemrajswarnkar9734
    @hemrajswarnkar9734 Рік тому +1

    very helpful video 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

  • @ShivamKatheriya-yz6wf
    @ShivamKatheriya-yz6wf 2 роки тому

    It's very interesting video of excel

  • @syedyousuf3531
    @syedyousuf3531 Рік тому

    Excellent teaching method

    • @Excel_Tutorial
      @Excel_Tutorial  7 місяців тому

      Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ua-cam.com/video/e_lb0FCAZ24/v-deo.html)

  • @TVSCDN
    @TVSCDN Рік тому +1

    Thanks a lot sir🎉🎉❤

  • @user-cx1tx8qd3b
    @user-cx1tx8qd3b 4 місяці тому

    Good information

    • @Excel_Tutorial
      @Excel_Tutorial  4 місяці тому

      Many many thanks 😊😊😊😊😊😊

  • @sandeepsirohi1437
    @sandeepsirohi1437 2 роки тому

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

  • @kamalsahu3324
    @kamalsahu3324 6 місяців тому +1

    Fantastic 😍

  • @SaurabhSharma-ry8iz
    @SaurabhSharma-ry8iz 2 роки тому

    Very informative video sir

  • @lucky-pm2pe
    @lucky-pm2pe Рік тому

    Excellent video sir

  • @sanjeevpavadad7634
    @sanjeevpavadad7634 2 роки тому

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

  • @lekhrajbairwa228
    @lekhrajbairwa228 Рік тому

    "Engaging and insightful teaching on a fascinating topic!"

  • @Altaf_Alam
    @Altaf_Alam 2 роки тому +2

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

  • @hariomsingh-en9ps
    @hariomsingh-en9ps 2 роки тому +1

    Super sir

  • @gautamkadam9131
    @gautamkadam9131 2 роки тому

    Acha explain kiya

  • @SUNILMAURYA-ju8iu
    @SUNILMAURYA-ju8iu 2 роки тому

    Nice sir

  • @drprabhakarbhagwat
    @drprabhakarbhagwat 2 роки тому

    Superb power query 🙏👌👌

  • @shashikantchaudhari1378
    @shashikantchaudhari1378 2 роки тому

    Excellent 👌 Sir 💐💐

  • @jitendrabomble2218
    @jitendrabomble2218 2 роки тому

    Thanks sir.
    Very useful information.

  • @AjitKumar-pt9jb
    @AjitKumar-pt9jb 2 роки тому

    Very fruitful video sir 👍

  • @arunkumarsinghark3024
    @arunkumarsinghark3024 2 роки тому +1

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

  • @naziriqbal3980
    @naziriqbal3980 2 роки тому

    good yar

  • @comking-g8v
    @comking-g8v Рік тому

    thank you sir I am working as a data analytics

  • @prabhakarpawar573
    @prabhakarpawar573 2 роки тому

    Very usefull sirji

  • @gorakhkhatele7238
    @gorakhkhatele7238 2 роки тому

    Very good sir

  • @arunkumarsinghark3024
    @arunkumarsinghark3024 2 роки тому +1

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

  • @judaysinghsidar8216
    @judaysinghsidar8216 2 роки тому

    Super

  • @Deepakkumar-ne1jq
    @Deepakkumar-ne1jq 2 роки тому

    Very interesting

  • @sabitrikc3047
    @sabitrikc3047 6 місяців тому

    Thanks kind information

  • @santoshmarkam4412
    @santoshmarkam4412 2 роки тому

    Nice sir good

  • @vikashgangwal9054
    @vikashgangwal9054 2 роки тому +3

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

  • @azzu2294
    @azzu2294 2 роки тому

    Tq so much sir for this wonderful video

  • @anandravi1498
    @anandravi1498 Рік тому

    Thanks for the update

    • @Excel_Tutorial
      @Excel_Tutorial  7 місяців тому

      Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ua-cam.com/video/e_lb0FCAZ24/v-deo.html)

  • @canirmalchoudhary8173
    @canirmalchoudhary8173 2 роки тому +1

    Amazing 👏

  • @aasifkhaniqbalkhan4108
    @aasifkhaniqbalkhan4108 Рік тому

    excellent

  • @bijaykumarmishra7689
    @bijaykumarmishra7689 3 місяці тому

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

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

  • @arunkumarsinghark3024
    @arunkumarsinghark3024 2 роки тому

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

  • @bijaytanty8434
    @bijaytanty8434 2 роки тому

    Thanks Sir👍

  • @khalidmajeed2886
    @khalidmajeed2886 Рік тому

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

  • @Mylifestoryofvicky
    @Mylifestoryofvicky 2 роки тому

    Good evening sir

  • @sanjeevsharma2306
    @sanjeevsharma2306 10 місяців тому

    Thanks

  • @manmohangawali3094
    @manmohangawali3094 2 роки тому

    Thank you sir

  • @warishawarisha870
    @warishawarisha870 Рік тому

    Sir aap konsa excel use krte h ?

  • @mdsani743
    @mdsani743 2 роки тому

    Thanks sir

  • @TilawatQuranPak123
    @TilawatQuranPak123 3 місяці тому

    thanks

  • @krishnanandankumar
    @krishnanandankumar Рік тому

    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

  • @rajeevvyas4854
    @rajeevvyas4854 8 місяців тому

    Thank

  • @kundanlal4133
    @kundanlal4133 Рік тому

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

  • @techsolutions533
    @techsolutions533 2 роки тому

    nice

  • @akbarwarsi7327
    @akbarwarsi7327 Рік тому

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

  • @nainaverma8673
    @nainaverma8673 Рік тому

    👌👌

  • @EVFinserv
    @EVFinserv 6 місяців тому

    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.

  • @manjit.sarania
    @manjit.sarania 2 роки тому

    I would like to buy power query and vba code course

  • @manojrock4428
    @manojrock4428 2 роки тому

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

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

  • @Vibhujitiwari
    @Vibhujitiwari Рік тому

    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.

  • @neharajput568
    @neharajput568 Рік тому

    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

  • @scacademy9680
    @scacademy9680 2 роки тому +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

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

  • @utsavmaidankar
    @utsavmaidankar Рік тому

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

  • @arunraj2.052
    @arunraj2.052 2 роки тому

    Sir ji office 2010 64bit provide kar dijiye please

  • @sanjeetsharma2700
    @sanjeetsharma2700 2 роки тому

    Sir define name tab ka video banaiye

    • @sanjeevverma927
      @sanjeevverma927 2 роки тому +1

      Ye video dekhiye problem solve ho jayegi-ua-cam.com/video/zjQNiYgMntI/v-deo.html

  • @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 - ua-cam.com/video/LXpeZreD068/v-deo.html

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

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

  • @susilasamal6754
    @susilasamal6754 Рік тому

    If the heading is different how we merge it.

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

  • @Sunilsingh-xm7lz
    @Sunilsingh-xm7lz Рік тому

    How to merge horizontaly

  • @SunitaChouhan-s6p
    @SunitaChouhan-s6p Рік тому

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

  • @nitinverma5842
    @nitinverma5842 2 роки тому

    Sir ye excel 2007 main kaam karega

    • @Excel_Tutorial
      @Excel_Tutorial  2 роки тому

      Nahi ye 2010 ke aage wale office me chalega.

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

  • @milindgupta8439
    @milindgupta8439 2 місяці тому

    I have found out about how to center horizontal cells without using "Merge and Center". I realized that it's absolutely useful but when trying to applying it in vertical cells, I can't find the same function in the Alignment Tab of Format Cells for vertical. Could anyone please share with me the way to do it?

  • @Official_Suraz
    @Official_Suraz Рік тому

    practice file download nahi horaha hai

  • @yogeshrao5924
    @yogeshrao5924 5 місяців тому

    Confusion Bahut he shreemaan

  • @sunitachauhan7386
    @sunitachauhan7386 Рік тому

    Please suggest sir 🙏🙏

  • @vijayuikey311
    @vijayuikey311 2 роки тому

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

  • @amanarman2113
    @amanarman2113 2 роки тому

    🙏🙏🙏

  • @sunitachauhan7386
    @sunitachauhan7386 Рік тому

    Dashboard Kaise banaye

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

  • @ejanghanse4661
    @ejanghanse4661 2 роки тому

    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 2 роки тому

      Excel ki jagah panda 🐼 pe work kro

  • @RohitRawat-jo1tw
    @RohitRawat-jo1tw 2 роки тому

    Consolidate se bhi ho jayegi kya sir

  • @sundarram763
    @sundarram763 2 роки тому

    How to convert pdf to excell in easy way

  • @mr.x3453
    @mr.x3453 2 роки тому

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

  • @spectragaming7018
    @spectragaming7018 2 місяці тому

    ha Data Kaha milega

  • @pankajknowledgeworld
    @pankajknowledgeworld 2 роки тому

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

  • @gaonkikheti7363
    @gaonkikheti7363 Рік тому

    Ads are so irritating 😔😔😔

  • @sanjeetsharma2700
    @sanjeetsharma2700 2 роки тому

    Sir please

  • @RohitKumar-cc7zi
    @RohitKumar-cc7zi 2 роки тому

    Your way of Teaching is😌 very confusing

  • @abdulghaffarasi6649
    @abdulghaffarasi6649 2 роки тому

    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.