+ Reply to Thread
Results 1 to 3 of 3

Re-arranging rows based on pre-defined order

  1. #1
    Registered User
    Join Date
    05-21-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re-arranging rows based on pre-defined order

    Hello everyone,

    I would like to re-arrange the rows of data on a pre-defined order. For instance,

    BAX
    BAX

    CGB
    CGB
    CGB
    CGB
    CGB

    OGB
    OGB
    OGB

    OBX
    OBX
    OBX
    OBX
    *spaced 3 rows apart from each other, and # of rows not fixed.

    I would like to rearrange it based on pre-defined order of: BAX & OBX, then CGB & OGB, so, the desired end result would be,

    BAX
    BAX
    OBX
    OBX
    OBX
    OBX

    CGB
    CGB
    CGB
    CGB
    CGB
    OGB
    OGB
    OGB



    Thank you so much in advance for your reply.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Re-arranging rows based on pre-defined order

    make a helpcolumn, and for BAX = 1, OBX =2, cgb=3, ogb=4

    then sort on the helpcolumn.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    05-21-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Re-arranging rows based on pre-defined order

    Thank you so much, completely forgot about that helpcolumn.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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