BOM template based on Indenture to ERP template

Dear Forum,

At our company, we have to upload very complicated long Bill of Materials into our new ERP system on a weekly basis. These BOM's are based on Indents (BOM Explosions). These are always multi-layered (endlessly), meaning, there is a BOM in a BOM. In the example, the product P1-A0000 is built of three components, and these three components are built out of other components.

The template we receive from the ERP system shows that in Row 1 we need the product and in Row 2 the components. However. I cannot seem to figure out how to write a formula that gets the result shown in columns 'Outcome'. It is not difficult to get Level 0 in row 1 and Level 2 in row 2, but to then get Level 2 in row 1 and then Level 4 in row 2, I do not seem to be able to figure it out.

I put another formula in there that removes all the blanks, maybe that helps you. Keep in mind that the formula/solution has to be expandable. These BOM's might consist out of 10 levels, but also multiple products on one level.

It is quite the challenge (for me at least), I am curious if any of you can find a solution!

Thank you so so much in-advance!