Hierarchy Build - Parent and Child are in same column
I am faced with this hierarchy where P1 and P2 are parents and Prior Items are Children of it.
I am bit confused how to build this hierarchy in system as data for both child are in same column in file.
Does anyone has an idea how I can accommodate this?
Consider structure of data exactly same as the image.