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 :)
Hi @8802036946 ,
One way of doing this is to use Record ID and Cross Tab tool.
Workflow
Cross Tab configuration
Good luck.