Reverse Transpose using INDIRECT Function | Ways to Transpose (Reverse or flip) Excel Data

Поделиться
HTML-код
  • Опубликовано: 15 окт 2024
  • Reverse Transpose using INDIRECT Function | Ways to Transpose (Reverse or flip) Excel Data
    1.How to reverse or flip data range in excel
    2. Ways to transpose excel data (rotate data from vertical to horizontal)
    3. Transpose Reverse using Indirect Function in hindi
    4. Transpose reverse using Sort in excel
    Music: www.bensound.com
    Excel Lookup Functions Playlist Link - • Excel Lookup Functions...
    Download the Assignment Master Practice Folder here (All Playlist Example at one place)
    drive.google.c...
    ===========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...
    #reversetranspose #reverseorflipdata#Innozant #transposedata#misinterviewquestions

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

  • @puransingh-sx2tk
    @puransingh-sx2tk 3 года назад +1

    Guru g aisa kuch hai jo excel nahi kar sakta Hahaha kaam ho aap 👌🏻 🙏

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

      Hahaha..Lots of love ❤️🙂♥️ for such a lovely appreciation

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

    Innozant excel student can easily become a financial modeler. Thanks to Dipak Sir for his unparalleled content and teaching style.

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

      Thanks Shrikant ❤️ for such a lovely comment dear..Hope your health is fine now..and you back on track.👍

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

    Very useful. Thank you sir.

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

    Sir nice video tha sir mujhe data science ke all topic ki list chahiye iss course mein konse topic aayenge

  • @RahulChauhan-ll9pu
    @RahulChauhan-ll9pu 3 года назад

    Super guru ji

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

      Thanks Chauhan Sahab👍🙏❤️

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

    excellent sir g..

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

      Thanks Adnan Sahab❤️🙏

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

    Awesome video sir good night. 🙏🙏🙏

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

      Thanks Satish Ji..Good Night ♥️👍🙏

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

    very excellent sir

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

    Excellent and Thanks you Sir

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

      Thanks Shivkesh ji♥️❤️🙏GM.hv a great day ahead

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

    Sir, the same problem can be solved with the help of power query as well right?. I feel with power query, chances of making a mistake is less and quicker also.

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

    Thank you sir...very helpful👍

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

      Thanks Suraj ..Happy learning dear

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

    Very very useful 👍❤️

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

      Thanks Alok Ji..GN❤️👍♥️

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

    Thanks Sir.

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

      Thanks ❤️❤️

  • @Abdulwaheed-pp1nj
    @Abdulwaheed-pp1nj 3 года назад

    Sir mindblowing

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

      Thanks Abdul Waheed Sahab👍🙏❤️

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

    Amazing

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

      Thanks Avanish🙏❤️

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

    U to good sir

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

      Thanks Gaurav Ji 👍♥️

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

    If I watched ur all videos then i understood that nobody can defeat me as a MIS executive post to get good job

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

      Very True Amrita, Recommend you to learn every playlist in sequence,After completion. Of conceptual part follow Mis interview cracker series.

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

    Jaise SQL python or aapse Jaan na hai , because all topic I don't know

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

    Amazing!!

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

      Thanks Ansh..👍👍🙏🙏❤️❤️

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

    Excelent , how can i ignore blank rows/columns using transpose formula.thanks

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

      Check bllank ..remove it with null followed by transpose

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

      @@Innozant I can't solve this problem by this method I am using excel 2019

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

    ❤️🙂

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

    If u go array function , file size becomes huge as comparisons normal one

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

    Sir aapne index fn kyu nahi use kiya instead of address and indirect

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

      Index se bhi btaya hai dear

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

    Sir,when you complete lookup function so pls complete it I request you

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

      Only Offset is remaining..will cover up soon...After That Vlookup Practice series starts for Advanced learner

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

    U can use if error function

  • @RakeshSingh-qo5nd
    @RakeshSingh-qo5nd 3 года назад

    Ye music wali video sunne ke baad mai ek bar pause kar ke cross check kiya ki kisi dusre app me song to nhi chal rha 😂

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

      Hahaha...Acha Ji..mere video me pehle koi music nhi rhta tha isliye..😀😀😀Haan intro me music dalana start kiya hai..🙏😀😀

  • @KoolCox
    @KoolCox 8 месяцев назад

    2019 wale me ye bawal nahi guru

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

    Salid logic

  • @AshishKumar-hc3km
    @AshishKumar-hc3km 2 года назад

    Sir mere me ho hi nhi rha hai

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

    Thanks sir.

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

      Thanks Tejpal Ji 👍♥️🙏

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

    Amazing