Closed Thread
Results 1 to 2 of 2

Quite a puzzler - Concatenate for unique entries

  1. #1
    Registered User
    Join Date
    04-15-2011
    Location
    Bucharest
    MS-Off Ver
    Excel 2007
    Posts
    2

    Unhappy Quite a puzzler - Concatenate for unique entries

    Hello,

    Presenting below quite a puzzler

    I have the following info on 3 columns; i am really curios if i can get the result mentioned below (meaning put the info on column 3 in a single cell where the first two cells have the same info - meaning for the unique two first column which i already have i need to write A,B,C or D,E,F next to them, as in the result)

    Is it really possible? Couldn't figure out any solution for this

    ARRAY:


    Word 1|Opt 1|A
    Word 1|Opt 1|B
    Word 1|Opt 1|C
    Word 2|Opt 2|D
    Word 2|Opt 2|E
    Word 2|Opt 2|F

    Result
    Word 1|Opt 1|A, B, C
    Word 2|Opt 2|D, E, F

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Quite a puzzler - Concatenate for unique entries

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

Closed Thread

Thread Information

Users Browsing this Thread

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

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