Hello,

I have a table with 2 columns: old code, new code.
I wish to generate a chain for each new code (string with all the old codes).

for example:
Input:

Old code, New code
A,C
B,C
D,B
..

Output:
C: A,B,D
B: D


What is the best way to implement this in excel ?

Thank you for your help