+ Reply to Thread
Results 1 to 3 of 3

Extract and stack

  1. #1
    Registered User
    Join Date
    03-12-2022
    Location
    Atlanta, Georgia
    MS-Off Ver
    365
    Posts
    94

    Extract and stack

    I'm loving the built in filter functions in 365 but was hoping to find a similar one to extract values and stacking them.

    I would like to pull names in each cell of Data table, which are separated by ";", and stack them separately in another column. I want to avoid using power query for a particular reason so was hoping to find a Filter or Array function........

    Data table is raw data. Output table is my desired results.

    Thanks
    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
    45,474

    Re: Extract and stack

    If the order is not important …
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    This formula MUST NOT be next to the Table. There must be at least one blank column between the Table and the formula output.
    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
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,416

    Re: Extract and stack

    If you want them in the same order as your sample output, you could use something like:

    =TOCOL(REDUCE("Name",Data[Names],LAMBDA(a,b,VSTACK(a,TEXTSPLIT(b,";")))),2,TRUE)
    Everyone who confuses correlation and causation ends up dead.

+ 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. Stack bar with log scale
    By cswshaun in forum Excel General
    Replies: 1
    Last Post: 06-13-2020, 04:18 AM
  2. [SOLVED] Out of Stack Space
    By IonutC in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-04-2019, 09:40 AM
  3. [SOLVED] Out of stack error
    By Jonathan78 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-13-2016, 04:09 PM
  4. stack word
    By Stews in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-22-2013, 03:10 PM
  5. Stack tabs?
    By dawgfan in forum Excel General
    Replies: 1
    Last Post: 10-02-2009, 02:53 PM
  6. Stack Overflow
    By DonHuff in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-07-2009, 03:30 PM
  7. [SOLVED] vba undo stack
    By anandb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2005, 02:06 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