Power Query Split Columns and Rows in Excel | Split Data into Rows with Power Query

Поделиться
HTML-код
  • Опубликовано: 19 окт 2024
  • Power Query Split Columns and Rows in Excel | Split Data into Rows with Power Query
    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...
    #powerquery #powerquerysplitcolumns#innozant #powerquerysplitrows

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

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

    Like your all videos ❤ tip top contents 😊

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

    In each video, I feel your love of teaching Gurujii. Nobody in this universe can teach like you. Pranaam 🙏🙏🙏

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

      Thanks Hemant ,aaapka yr feedback bht mayne rakhta h mere liye

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

      Gurujii... It is a public platform. Hence, I can't reveal my identity here. I could give you my learning experience with you in written through email or some other sources. I believe this feedback would help you in your business. I have dropped an WhatsApp message.... Pranaam Gurujii.

  • @eighttech
    @eighttech 8 месяцев назад +1

    Thanks ❤

  • @abidurrahmanabir7745
    @abidurrahmanabir7745 5 дней назад

    Amezing Presentation brother... ❤️

  • @sandeepaswal8944
    @sandeepaswal8944 3 года назад

    Sir Very Professional way of teaching. Thank you for creating this tutorial.

    • @Innozant
      @Innozant  3 года назад

      Thanks Sandeep ji .👍❤️❤️❤️

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

    What a brilliant approach sir, this helped me out thoroughly for one of the my complex project. Pranam Sir 👏🏼

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

      Thanks Deepak..Keep Learning.Keeo Exploring 👍❤️

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

    Very nicely explain sir, many many thanks for sharing knowledgeable videos absolutely free.

  • @hbp7633
    @hbp7633 3 года назад

    Bhaai tu Excel ka Bhagvaan hai.
    I salute you sir. You have such a great zeal on your work.
    After all work is worship.

    • @Innozant
      @Innozant  3 года назад

      Thanks for your lovely appreciation dear..God bless you..have a greay day🙏❤️

    • @hbp7633
      @hbp7633 3 года назад

      @@Innozant
      Sirji, is there any way where we can download / add-in Office 365’s some functions to office 2013. Fxs like Filter, Let, Sort etc... There must be a way... And thank you for your comment too.

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

    Brilliant Guru Ji 🙏🙏 very effective for my office day to day activity

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

      Thanks dear❤️👍

  • @GaganDeep-mj5hi
    @GaganDeep-mj5hi 2 года назад

    You are Great teacher

  • @mjaved701
    @mjaved701 3 года назад +1

    Great sir, this time too much time has been taken by you for uploading power query lecture. Credit🤗🤗🤗 to your efforts. Dil se

    • @Innozant
      @Innozant  3 года назад

      Thanks ❤️🙏Javed sahab

  • @GaganDeep-mj5hi
    @GaganDeep-mj5hi 2 года назад

    Very nice content

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

    Thank you sir 👋👋👋👋👋

  • @satishojha6240
    @satishojha6240 3 года назад

    Excellent video sir thanku 😇😇😇😇

    • @Innozant
      @Innozant  3 года назад

      Good Morning .. Thanks Satish Ji

  • @khalidalisubhanallah2947
    @khalidalisubhanallah2947 3 года назад

    Very knowledgeable video Bundle of thanks 👍♥️

    • @Innozant
      @Innozant  3 года назад

      Thanks bKhalid sahab🙏❤️

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

    Thanks lot of thanks

  • @Harish.Prasad.Semwal
    @Harish.Prasad.Semwal 7 месяцев назад

    Very nice sir.

  • @jayantabhattacharyya628
    @jayantabhattacharyya628 3 года назад

    Dear Sir
    Now I am gradually feeling the beauty of power query through your tutorial. I hope more amazing features of power query I am going to learn from your tutorials.
    Thanks & Regards
    Jayanta Bhattacharyya

    • @Innozant
      @Innozant  3 года назад

      Thanks Jayanta...sure dear🙏❤️

  • @veerdhadra
    @veerdhadra 3 года назад +1

    Superb...!!

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

    Amazing sir thank u

  • @nageshwarlal9967
    @nageshwarlal9967 3 года назад

    Sir, please upload more powerful powerful feature videos of poweer query frequently...... I m your big fan sir........ You are the best teacher and best content provided by you on internet

    • @Innozant
      @Innozant  3 года назад

      Thanks Nageshwar Ji..Sure dear🙏❤️

  • @TheSuvankarKundu
    @TheSuvankarKundu 3 года назад

    After sooooo long.. We wait for ur vds everyday.. Pls upld vds frequently..

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

    Thanks sir

  • @meditationmusic6482
    @meditationmusic6482 3 года назад

    Thanks sir ji

    • @Innozant
      @Innozant  3 года назад

      Thanks dear🙏❤️

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

    thanks video

  • @hemlatasharma2082
    @hemlatasharma2082 3 года назад

    Like ur all videos sir

    • @Innozant
      @Innozant  3 года назад +1

      Thanks Hemlata..God bless you.Happy Learning ❤️❤️

    • @hemlatasharma2082
      @hemlatasharma2082 3 года назад

      @@Innozant sure sir,, thanks

  • @aqeelahmadengr3
    @aqeelahmadengr3 3 года назад

    Well-done

    • @Innozant
      @Innozant  3 года назад

      Thanks 🙏❤️

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

    ❤❤❤❤❤❤❤

  • @arshadalam6109
    @arshadalam6109 5 месяцев назад

    Good❤

  • @durgeshrai8938
    @durgeshrai8938 3 года назад

    Great sir

    • @Innozant
      @Innozant  3 года назад

      Thanks Durgesh Ji🙏❤️

    • @durgeshrai8938
      @durgeshrai8938 3 года назад

      Sir again aap freser mis ka vidio upload kre
      Technical & machine round 🙏

  • @jaynarayan1963
    @jaynarayan1963 3 года назад

    Nice👍👍

    • @Innozant
      @Innozant  3 года назад +1

      Thanks Jay❤️🙏

  • @vivekthakur2334
    @vivekthakur2334 3 года назад

    Nice Sir

    • @Innozant
      @Innozant  3 года назад

      Thanks Vivek ji🙏❤️

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

    ❤️❤️❤️❤️

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

    Thank you, 2016 me Split me options sirf 2 he hai

  • @RahulRoy-po9ct
    @RahulRoy-po9ct Год назад

    🙏

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

    How to get personalized training .. please advise

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

      Sorry we don't provide personalized training,You may join our live or offline batches .For more information kindly visit Innozant website

  • @RomanReigns-oh2dz
    @RomanReigns-oh2dz 3 года назад

    Hii sir
    Do you teach C language too?

  • @mahaminmondal6248
    @mahaminmondal6248 3 года назад +1

    Sir, I am facing an issue in Excel. I have some phone numbers on sheet no. 2 and I want to paste those phone numbers to the empty cells on sheet no. 1 without overwriting the existing phone numbers on sheet no 1. I want to paste the phone numbers from sheet no 2 to the blank cells only on sheet no 1

    • @Innozant
      @Innozant  3 года назад +1

      Share your sheet with detail query explanation in @innozantofficial telegram id

    • @mahaminmondal6248
      @mahaminmondal6248 3 года назад

      @@Innozant Sir, I have sent that to the telegram id you have mentioned

  • @harishpandey168
    @harishpandey168 3 года назад

    Very Nice sir...I have a querry...Suppose in a column..where few fig are positive and few are negative..Below that I want to sum only the positive fig...Whether this can be done...Plz tell sir...😊😊

    • @Innozant
      @Innozant  3 года назад

      Criteria me "(>0) pass kar dijiye🤗🙏❤️

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

    sir marge column ke bad two delimiter use kasie karnege please answer

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

      Kya transform karna chahte hain?

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

    Sir mere excel 2016 h but mere me Kai sare power query k options ni dikh Rahe h jaise ap me dikh Rahe h
    Aise me kya kare sir
    Plz help

  • @krishnasharma-ip6hk
    @krishnasharma-ip6hk 2 года назад

    Sir,row mai India double aa rha h usko single hi rkhna h to kese hoga

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

    In my laptop only two option 1) By delimiter
    2) By number of character
    Are available. Rest are not.why? How can i get it? Plz help.

  • @syedasifimamrizvi
    @syedasifimamrizvi 3 года назад

    Thanks Sir, aap ki video mereleya very helpful hai. aapne marks% basis per if ka function lagana sikhya bahut helpful raha mereleya but sir mera ek question hai, sir kisi bhi student ko ek bhi subject agar 33% se kam number aye to use "fail" show karna hai jabki us student total %> 33 or >45 >60 hai tab bhi. sir maine karne ki koshish ki par nahi hoo raha hai sir plz help me.

    • @syedasifimamrizvi
      @syedasifimamrizvi 3 года назад

      Sir main 50% kamyab hoo gaya hoo. subject ka aur total marks ka criteria full fill ho raha hai to results 1st, 2nd...... show kar raha hai but subject ka criteria full fill nahi hone per who False show kar raha hai but mujhe result Fail show karna hai. plz sir help me plz.

  • @syedasifimamrizvi
    @syedasifimamrizvi 3 года назад

    Sir maine karne ki koshis ki but nahi hoo raha hai sir plz help me

    • @Innozant
      @Innozant  3 года назад

      Aisa kyu?kya prob face kar re h aap

  • @RahulRoy-po9ct
    @RahulRoy-po9ct Год назад

    🙏