Good evening all,

I have a table in columns “A” and “B”. It is known as a BOM (Bill of Material) and column “A” is the parent of column “B” the child. Some Codes have a child which may also have a child etc etc BUT they do not always have the same amount of levels. In my example table A001 has two children of “A005” and “A006”, each then has their own MCode child. However, A002 does not have any child ACode and only has the child “M002”.

I have tried various loops to convert the table in columns “A” and “B” into the table in columns “D” to “G” but the dynamic levels the children goto means I just cant get it to work. Some investigation suggests a recursive function but am unable to implement despite various attempts.

Any support appreciated (not worried about the formatting in columns “D” to “G” but have put it in to aid understanding). If you have any questions to aid understanding of my request then I am happy to answer any of them.

Many thanks, Alan.