Format Data using input "Input_File" and desired output is like "Output_File"

[8802036946]

Input files has column : Names and Hierarchy/Level
Trying to get 2 desired results as Output_File attached having 2 worksheets in it, Creating Hierarchy based on levels from input. 

Thanks for you help :)

[geraldo]

@8802036946 

An example 

[Yoshiro_Fujimori]

Hi @8802036946 ,

One way of doing this is to use Record ID and Cross Tab tool.

Workflow

Cross Tab configuration

Good luck.