I have parent child relationship in two column excel sheet want a excel formula to derive all child and subchild against each row in third column

Asked Mar 26 '21 at 20:18

Active Mar 27 '21 at 15:51

Viewed 192 times

I have parent child relationship in two column excel sheet want a excel formula to derive all child and sub-child against each row in third column

Input is in excel columns

column1 columnn2 Child Parent B A C B D C E C F E G A T G YU D

Output will be in third column column 1 Column2 Column3

Child Parent All childs B A B,C,D,E,F,G,T,YU C B C,D,E,F,YU D C D,E,F,YU E C D,E,F,YU F E F G A B,C,D,E,F,G,T,YU T G T YU D YU

edited Mar 27 '21 at 15:51

asked Mar 26 '21 at 20:18

Please post the input and output in the question in place of the images – Deepak Patankar Mar 27 '21 at 05:24
Input is in excel columns column1 columnn2 Child Parent B A C B D C E C F E G A T G YU D Output will be in third column column 1 Column2 Column3 Child Parent All childs B A B,C,D,E,F,G,T,YU C B C,D,E,F,YU D C D,E,F,YU E C D,E,F,YU F E F G A B,C,D,E,F,G,T,YU T G T YU D YU – VIMAL KUMAR CHAUHAN Mar 27 '21 at 07:00

0 Answers0