+ Reply to Thread
Results 1 to 4 of 4

Combine 2 columns into 1 column, order is in a "zigzag" fashion

  1. #1
    Registered User
    Join Date
    04-15-2022
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    365 ProPlus
    Posts
    5

    Combine 2 columns into 1 column, order is in a "zigzag" fashion

    Hi,

    I'm looking to combine two columns into one, but the order is dependent on the value in the first column. As the value in the first column repeats, it will stack its values in the second column below it until it finds a new unique value in the first column, then it does the same for this new unique value. Not sure if a lookup/match function could work. Any ideas? See sample workbook attached:

    Pasadena.xlsx

    Example:

    A ant
    A bird
    A cat
    B dog
    B elephant

    Result:

    A
    ant
    bird
    cat
    B
    dog
    elephant
    Last edited by fallfromgrace; 03-20-2024 at 11:32 PM.

  2. #2
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Combine 2 columns into 1 column, order is in a "zigzag" fashion

    Use this formula.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-15-2022
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    365 ProPlus
    Posts
    5

    Re: Combine 2 columns into 1 column, order is in a "zigzag" fashion

    This works, thank you so much!!

  4. #4
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Combine 2 columns into 1 column, order is in a "zigzag" fashion

    Tks for the feedback, glad to have 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] Formula to count "low", "med", or "high" in 4 columns of data split by fiscal quarter
    By Kerry1980 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-11-2022, 06:58 AM
  2. [SOLVED] VLOOKUP to compare 2 columns and return "Yes" or "No" in 3rd column
    By rmccain in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-05-2017, 09:38 PM
  3. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  4. Replies: 1
    Last Post: 01-22-2016, 09:21 AM
  5. [SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2013, 08:28 PM
  6. Replies: 11
    Last Post: 04-16-2013, 06:21 PM
  7. [SOLVED] Generate "ascending order no" for columns of data that are not in order
    By abreichenbach in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-20-2013, 02:22 AM

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