Split columns by Hierarchy

Hi team,

I need your help to separate one columns from level wise like Assets,Income,Expenses,LIABILITIES are should be in Level 1 field. Same as like I have to separate all the values by Level 2, level3, etc...

In level one should have it sub Categories like Current Asset, Non-Current Asset,etc...

here i am Attaching the image