+ Reply to Thread
Results 1 to 3 of 3

Lookup and return multiple values concatenated in one cell

  1. #1
    Registered User
    Join Date
    09-27-2012
    Location
    Hawaii
    MS-Off Ver
    Excel 2013
    Posts
    10

    Lookup and return multiple values concatenated in one cell

    I have a two column, eight row table that looks like this:

    John apples
    John oranges
    John bananas
    Bob mangos
    Bob papayas
    Bob pineapple
    Jeff berries
    Jeff oranges


    And I want to transform it to a two column, three row table like this

    John apples; oranges; bananas
    Bob mangos; papayas; pineapple
    Jeff berries; oranges

    How do I do this?

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2405
    Posts
    13,434

    Re: Lookup and return multiple values concatenated in one cell

    Your join date is @ 6 years ago, and you profiled Excel 2013. Is there is any chance you have upgraded to Office 365 (subscription 2016) since then?

    There is a function that will handle that called TEXTJOIN. That would be the simplest way.

    Otherwise you will need VBA.

    Please let us know.
    Dave

  3. #3
    Registered User
    Join Date
    09-27-2012
    Location
    Hawaii
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Lookup and return multiple values concatenated in one cell

    Thanks I will give it a shot. I do have 365, but I mostly use 2016.

+ 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. Concatenated lookups and return multiple values
    By Mikeyabosbht in forum Excel General
    Replies: 12
    Last Post: 07-05-2018, 04:14 PM
  2. return multiple header cell values into one cell concatenated based on a cell value
    By anchuri_chaitanya in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-13-2016, 10:27 PM
  3. Lookup and return multiple values concatenated into one cell
    By funinsum in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-09-2015, 06:26 PM
  4. Replies: 2
    Last Post: 12-04-2013, 04:21 PM
  5. Lookup multiple values concatenated into one cell without duplicates
    By Atul Maskara in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2013, 09:33 AM
  6. [SOLVED] Match multiple substrings in a cell against a lookup table and return concatenated values
    By stevewc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2013, 10:50 AM
  7. Lookup and then return multiple values concatenated
    By cjcass in forum Excel General
    Replies: 1
    Last Post: 11-01-2012, 03:19 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