converting a table to a hierarchy

[Faixal]

Hello Alteryx Community,

I need your expertise and guidance! I'm currently trying to convert a table to a hierarchical format. My dataset consists of items, parents, and other attributes(please see the table below)

Item	Parent
A
B	A
C	A
D	A
E	B
F	B
G	C

I want to flatten it so that it is easy to see and identify the relationships between items. The output format doesn't matter much to me as long as I can quickly identify the hierarchy. I tried creating an output similar to either of the outputs below.

Level 1	Level 2	Level 3
A
	B
		E
		F
	C
		G
	D

or 

Level 1	Level 2	Level 3
A
A	B
A	B	E
A	B	F
A	C
A	C	G
A	D

I tried using macros to iterate over the whole dataset but failed miserably. Honestly, I don't think my logic was sound, hence why I'm not going to provide it here. Please help me.

Note: I don't know how many levels my data has as I have thousands of rows but it's definitely more than 10.

[Raj]

@Faixal 
find workflow attached
mark done of solved.