Hi,

I have 2 columns: Column A displays "accID" and Column B displays "projID",
this is one-to-many relationship (each accID may have many, or none, projID).

Example:

AccID, ProjID
3010 0
3011 200
3011 300
4010 50
5050 0
6010 300
6010 500

In column C I have written down all unique AccID and in Column D I want to
write a function that merge all ProjID (see below):

3010 | 0
3011 | 200, 300
4010 | 50

Is this possible, or do I need to revert to VBA?

Kindly,
Mikael
Sweden