Results 1 to 4 of 4

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

Threaded View

  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.

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