Creating new table

[Nikhil9403]

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!

[pedrodrfaria · Accepted solution]

Hi @Nikhil9403 

If I understood what you are looking for correctly, this could be the solution you are looking for:

Pedro.

[Nikhil9403]

Thank you @pedrodrfaria for your help. That is what I was looking for!