BOM explosions (different formats)

Dear Forum,

At our company, we have to upload very complicated Bill of Materials (BOM) 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.

From my previous thread from a couple of months ago, I got great help from WideBoyDixon regarding this issue. https://www.excelforum.com/excel-for...ml#post5592700

However, I assumed that most BOM's that we received are based on BOM Explosions which are Level 2 Indents, but I came to the conclusion that more often than not, this is not the case and two other ways are distributed too. (1) is that spaces are used instead of indents and (2) is that level 1 indents are used instead of level 2.

I need your help to update the macro written in the previous thread (I will write it in the comment below). I don't know rather it is possible to use one macro that identifies what is used, changes the spaces to indents, and indents 1 to 2, and then make the BOM outcome correctly after. I would need your advice, maybe three buttons are better? (1 for spaces to indents, 1 for indents 1 to indents 2, and 1 for indents 2 to BOM outcome)

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!