How to merge duplicates while concatenating unique data from 3 columns

**mdhillyer** · 09-11-2012, 12:55 AM

I need to delete all duplicate values in A but concatenate all unique values for B and C.

For example:
A/ B/ C
1 A a
2 R a
3 C a
4 T a
3 Y b
4 E b
5 A b
2 U c
3 E c
7 Q c

Needs to be:

A/ B/ C
1 A a
2 R a;c
3 C;Y a;b;c
4 T;E a;b
5 A b
7 Q c

Thanks in advance

**nilem** · 09-11-2012, 01:10 AM

try it

Please Login or Register  to view this content.

edited (without y()):

Please Login or Register  to view this content.

**jindon** · 09-11-2012, 01:10 AM

If this is not what you wanted, need to see the file.

Please Login or Register  to view this content.

**Mordred** · 09-11-2012, 01:12 AM

Hi mdhillyer, it would be in your best interest to upload a workbook with non-sensitive/personal data. Provide a before and after scenario as well. If you do this I'm sure your problem will be solved (hopefully) quickly.