Splitting IDs using one reference column

[KarthickDijo]

Hi All,

I need to create two separate columns (Parent & Child) from a Single column. Can anyone help me on this attached the sample input and output format.

Thanks in advance !!

 

[SanjayGMusafir]

Upload a sample data using XL2BB. What you need can be done easily.

 

[KarthickDijo]

I couldn't use the XL2BB tool. The Mini Sheet option is disabled. Could you please help me by viewing the image attached ?

 

[KarthickDijo]

@Fluff .. Just review the other query as well both are different actually. Here I requested for all possible combinations. Whereas the locked topic wasn't related to this one.

 

[SanjayGMusafir]

Check this - You can skip the part or rearrange as per your need

All Records.xlsb
	A	B	C	D	E	F	G	H	I	J
1	Name	ID	Help		Name	Parent	Child1	Child2	Child3	Child4
2	ABC	403	1		ABC	403	445	317	443
3	ABC	445	2		XYZ	371	352
4	ABC	317	3		RST	322	366	329
5	ABC	443	4
6	XYZ	371	1
7	XYZ	352	2
8	RST	322	1
9	RST	366	2
10	RST	329	3
Sheet1

Cell Formulas
Range	Formula
E2:E4	E2	=UNIQUE(A2:A10)
F2:F4	F2	=XLOOKUP(1,($A$2:$A$10=$E2)*($C$2:$C$10=1),$B$2:$B$10,"")
G2:G4	G2	=XLOOKUP(1,($A$2:$A$10=$E2)*($C$2:$C$10=2),$B$2:$B$10,"")
H2:H4	H2	=XLOOKUP(1,($A$2:$A$10=$E2)*($C$2:$C$10=3),$B$2:$B$10,"")
I2:I4	I2	=XLOOKUP(1,($A$2:$A$10=$E2)*($C$2:$C$10=4),$B$2:$B$10,"")
J2:J4	J2	=XLOOKUP(1,($A$2:$A$10=$E2)*($C$2:$C$10=5),$B$2:$B$10,"")
Dynamic array formulas.

 

[Fluff]

Just review the other query as well both are different actually.

You are quite right, my apologies for that. I have re-opened your other thread.

 

[KarthickDijo]

No actually the

You are quite right, my apologies for that. I have re-opened your other thread.

Thanks @Fluff !! Actually I used similar sort of example. But my requirement is different.

 

[KarthickDijo]

@JGordon11 Is there any solution for the above thread using PQ ??