Create a hierarchy from a single field

PATH() is correct.  Replace all periods with pipes.  Then use PATH.

Hi,

Thanks for the solution lbendlin  provided, it is excellent, and i want to offer some more information for user to refer to.

hello des_san , based on your description, you can refer to the following solution.

Sample data 

You can create the following calculated columns

Path = SUBSTITUTE([Column1],".","|")

Level 1 = PATHITEM([Path],1)

Level 2 = PATHITEM([Path],2)

Level 3 = PATHITEM([Path],3)

Level 4 = PATHITEM([Path],4)

Output

If the solutions lbendlin  and i provided can help you solve the problem , please consider to mark them as a solution.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.