Creating a hierarchy structure with formulas

Greetings

I have a sample file where I would like to use formulas to break/split column A into multiple columns that follows a hierarchy structure. I did use the search but most results were coming up in VBA and macros. My original file (not the sample provided) is 2000+rows and was originally a CSV file.

Thank you for any insight into this.