Creating Hierarchy

[Mattcrowie]

Hi! 

I am attempting to create a hierarchy with my dataset as follows: 

Each part number is assigned certain subparts (2, 2.1, 2.2 etc.). One part number could be assigned 3 different subparts for example.

Input so far is as follows:

I have managed to get the subparts in order but I am struggling to separate the subparts into different columns mimicking the hierarchy shown below. Expected output:

[Qiu]

@Mattcrowie 
Just as a start

[Yoshiro_Fujimori]

Hi @Mattcrowie ,

Another way of doing this.

Assuming the part number is separated with period('.'), you can get the level to use it as separate columns later.

Input

Workflow

Output

I hope this may be of some help. Good luck.