Need Some Serious Help in Excel Work

Hi, mathetes    HansVogelaar  excel, need to find some query from a cell and copy them to column in new sheet. Also need to align rows firstly Parent and Secondly Child.   Parent is Configurable ...