Multiple Parent to Child Roll Up

[jacbue79]

I have a dataset that looks like below:

Child 1	Parent 6	Parent 5	Parent 4	Parent 3	Parent 2	Parent 1
ABC123	Category 1	Category A	...	...	...	...
ABC124	Category 4	Category A	...	...	...	...
ABC125	Category 1	Category B	...	...	...	...
ABC125	Category 2	Category C	...	...	...	...

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

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

Thanks in advance for the help!

[geraldo]

@jacbue79 

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

[kamal03]

Hi @jacbue79 

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

[apathetichell]

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.