Collapsing Hierarchy

[Shaaz]

Hi,

I've data like below.

Here, ID is employee id.

I referred the link: Building a Hierarchy (With Kevin Bacon) * - Alteryx Community

From this we will get to know Parent-Child relationship.

I would like to get the data like below dynamically as the rows will increase with various Designation.

[binuacs]

@Shaaz There is a weekly challenge about the hierarchy, this might be helpful for your use case 

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-12-Creating-an-HR-Hierarchy/td-p/36740