Calculate chains of codes

[Snoopy2003]

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

[FDibbins]

Hi snoopy

It looks like almost 40 people have looked at your thread, yet you have no responses

Perhaps it would help if you explained a bit more what you are trying to do, and how you arrived at your expected outcome?

[Snoopy2003]

Hello,

I attached an example file with 2 sheets.
code sheet - 2 columns - new code, old code
stck sheet - stock for each code per month

My goal is to update stock according to codes chians.
I go over the new code column and for each code I sum the stock of old parts.
for example:
for code 'C' I sum the stock for C,B,A,D,E
for code 'B' I sum the stock for B,D,E
for code 'D' I sum the stock for D,E.

I wish to find the best way to calculate this.
First I wish to generate code chains and the go over the stock table and calculate it.
Another way is to implement some data structure like linked list and store codes with stock data.
I will appriciate if you tell me how do you think I should implement this.

Thank you for your help