Multiple Parent to Child Roll Up

Question

I have a dataset that looks like below:

Child 1Parent 6Parent 5Parent 4Parent 3Parent 2Parent 1ABC123Category 1Category A............ABC124Category 4Category A............ABC125Category 1Category B............ABC125Category 2Category C............

I want to roll up the child data to all the parents associated with it based on hierarchy like below:

Parent 1Parent 2Parent 3Parent 4Parent 5Parent 6ChildXYZ       XYZ       XYZ       XYZ       XYZ       XYZ       ABC123      ABC124  XYZ1       XYZ1       XYZ1       XYZ1       ABC125      ABC124   XYZ2       XYZ2       XYZ2       ABC129      ABC128    XYZ3       XYZ3       ABC127     XYZ3       ABC127XYZ4       ...

Thanks in advance for the help!

apathetichell · Answer

unclear if you want to keep the blanks in your output - but yeah some sample data and then using the cross tab tool should do it.

kamal03 · Answer

Hi @jacbue79

Could you please provide the correct sample input and output, I am not able to understand the example above.

geraldo · Answer

@jacbue79

Sorry. I would like to help but I don't understand the example you put as sample data