iterative Macro Hierarchy

[BRRLL99]

Hi

I have following dataset

Parent	Child
A1	X1
A1	X2
A1	X3
A1	B
B	Y1
B	Y2
C	S1
C	S2
C	S3
R	Z1
D	E1
D	E3
Y1	L1
Y1	L2
Z1	J7

Expected Output: 

I have build a iterative macro for the output, I'm looking for optimized workflow

A1	X3
A1	X2
A1	X1
A1	B	Y1	Y2
B	Y1`	L1
B	Y2
C	S1
C	S2
C	S3
R	Z1	J7
D	E1
D	E3
Y1	L1
Y1	L2
Z1	J7

[PhilipMannering]

Please try the solution I posted here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Hierarchy-data-with-Iterative-... 

If this is not what you need then let me know why!

[BRRLL99]

the issue in my original data I have 

same data points in both parent and child items 

please let me update the data again