I have hierarchy as per below example :
Parent 2(This is nothing but child1 in some case)
In my excel, I have column :
I have tried different options like partition , split into hierarchy etc but was not able to import the hierarchy as per above structure. Can someone help me with detailed step by step process?