+ Reply to Thread
Results 1 to 4 of 4

Transpose Conditional Formula

  1. #1
    Registered User
    Join Date
    06-01-2023
    Location
    Philippines
    MS-Off Ver
    365
    Posts
    2

    Post Transpose Conditional Formula

    Good day all,

    I need help on excel, can some one teach or show me a conditional formula in excel on how to add column in between of a column.
    I have 1000 columns to insert with. Please see image below for reference

    And I need to transpose them as row with row inbetween

    thank you
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,462

    Re: Transpose Conditional Formula

    Try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    06-01-2023
    Location
    Philippines
    MS-Off Ver
    365
    Posts
    2

    Re: Transpose Conditional Formula

    Thank you very much TMS. problem solved. I will update the tread as well

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,462

    Re: Transpose Conditional Formula

    You're welcome.



    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Conditional transpose
    By srini_tbcl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-23-2019, 04:02 AM
  2. [SOLVED] Transpose a conditional array formula
    By perducci in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-31-2016, 07:10 PM
  3. Three column conditional transpose
    By greek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-30-2014, 04:41 AM
  4. [SOLVED] Conditional transpose
    By greek in forum Excel General
    Replies: 3
    Last Post: 09-29-2014, 04:53 PM
  5. Conditional transpose per 2nd, 3rd or 4th row
    By greek in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-19-2013, 03:30 PM
  6. conditional transpose complex
    By susriram in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-30-2011, 01:00 AM
  7. Conditional transpose to Array
    By reachthepalace in forum Excel General
    Replies: 0
    Last Post: 03-01-2006, 06:36 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1