String and Substring (BOM)

Hello,

I am trying to create BOM report on Tableau. I have material and components. However, sometimes one of the components of material is also material and has its own components. I am trying to list all of them at the one view. Desired output is:

I tried this but returned null.

IF CONTAINS([Material],[Component]) then

{ FIXED [Material]:MIN(IF [Material]=[Component] then

[Component] end)}

else [Component]

END

Please keep in mind that I use 5 different datasources to build this view and I will have to list tens of materials like this. I used one as an example.

Thank you