Hi guys, a question was asked to me in interview where input is given as in 'Input.xlsx' (attached) file and output should be like 'Output.xlsx'(attached) file. I was able to answer for 'Parent' column from 'Output.xlsx' but was not sure how to generate column 'Child' from 'Outpur.xlsx'. Could anyone help to do it? As per my understanding, 'Multi-Row Formula' tool can be used to generate 'Child' column but need an approach to do it!
