+ Reply to Thread
Results 1 to 6 of 6

Combine rows of data into 1 cell based on unique identifier

  1. #1
    Registered User
    Join Date
    09-10-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    4

    Combine rows of data into 1 cell based on unique identifier

    Hi,

    Is there a formula that can help combine the data from multiple rows into 1 cell based on a unique identifier?

    attached the file sample..

    thanks
    Judy
    Attached Files Attached Files

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016
    Posts
    3,349

    Re: Combine rows of data into 1 cell based on unique identifier

    Hi,

    How about

    =SUMIF($A$2:$A$10,A2,$C$2:$C$10)

    in E2?
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    09-10-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Combine rows of data into 1 cell based on unique identifier

    thanks, fixed for column E. how about column D which is the text field...

  4. #4
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016
    Posts
    3,349

    Re: Combine rows of data into 1 cell based on unique identifier

    I'm sorry, but I can't see what you need from column D

  5. #5
    Registered User
    Join Date
    09-10-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Combine rows of data into 1 cell based on unique identifier

    Hi Sweep,

    When i run below udf, it will join the business units into a single cell based on the unique ID. how can i amend the udf to return the desired results without duplicates?
    Please Login or Register  to view this content.
    Opportunity Id Business Units Desire Results
    1-4BV05ZXXX ABC ABC, DEF
    1-4BV05ZXXX DEF ABC, DEF
    1-4BV05ZXXX ABC ABC, DEF
    Last edited by Leith Ross; 09-11-2010 at 05:04 PM. Reason: Added Code Tags

  6. #6
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Combine rows of data into 1 cell based on unique identifier

    Hello jud_goh,

    Welcome to the Forum!

    To make posts easier to read, copy and edit, please use code tags. I have done this for you because you are new. Do take some time to read the forum rules. By doing this, you help others to respond quickly to your questions.

    As a new member, please take some time to familiarize yourself with the rules.
    Click here for the Forum Rules

    Sincerely,
    Leith Ross
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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