Convert list to tree

[regresss]

Hi,

I have 2 column table (name, subname). I would like to look up whether each subname for a given name is also used as a name and has a subname. If yes, add this subname behind original subname and repeat for the new subname unless no subname is left, then next row.

Any idea?

I can calculate the number of rows needed for level 1 by countif(submember,list of submembers) but what about deeper levels?

 

[regresss]

Note the problem was posted on other forum as well: https://www.excelforum.com/excel-general/1230340-convert-list-to-tree.html