How to represent a tree in table

[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.

Any idea?

 

[regresss]

Quickly solution could be to create pivot table for each submember-member relationship but that is manual (as many tables as there as layers).