Getting all child values for every parent value based on a column

I have this data :  Parent Child Type 1 3 E 2 102 F 3 5 F 3 4 E 4 6 E 7 170 F 8 9 E 9 10 E 10 11 E 11 110 F 12 120 F 13 14 E 14 1...