Combine rows of data into 1 cell based on unique identifier

**jud_goh** · 09-10-2010, 12:32 PM

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

**sweep** · 09-10-2010, 01:45 PM

Hi,

How about

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

in E2?

**jud_goh** · 09-10-2010, 09:08 PM

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

**sweep** · 09-11-2010, 02:55 AM

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

**jud_goh** · 09-11-2010, 09:47 AM

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

**Leith Ross** · 09-11-2010, 05:06 PM

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