Multi Row Formula to Fill up

[Divyajyothi7]

Hi Have following dataset 

RecordID	Name	Value
1	od z_ritm	SD04567
1	od z_aitm	SD33358
1	od z_qna	1
1	z_aitm	SD09111
1	z_qna	1
1	z_aitm2	SD08111
1	z_qna2	1
1	z_aitm3	DG00790
1	z_qna3	1
1	z_aitm4
1	z_qna4
1	z_aitm5
1	z_qna5
1	z_aitm6
1	z_qna6
1	Right_od z_aitm	SD09898
1	Right_od z_qna	0.3
1	Right_z_aitm
1	Right_z_qna
1	Right_z_aitm2
1	Right_z_qna2
2	od z_ritm	SD04567
2	od z_aitm	SD33358
2	od z_qna	1
2	z_aitm	SD09111
2	z_qna	1
2	z_aitm2	SD08111
2	z_qna2	1
2	z_aitm3	DG00790
2	z_qna3	1
2	z_aitm4
2	z_qna4
2	z_aitm5
2	z_qna5
2	z_aitm6
2	z_qna6
2	Right_od z_aitm	SD09899
2	Right_od z_qna	0.25
2	Right_z_aitm	SD07777
2	Right_z_qna	1
2	Right_z_aitm2
2	Right_z_qna2

Expected Output:

RecordID	Name	Value
1	od z_ritm	SD04567
1	od z_aitm	SD33358
1	od z_qna	1
1	z_aitm	SD09111
1	z_qna	1
1	z_aitm2	SD08111
1	z_qna2	1
1	z_aitm3	DG00790
1	z_qna3	1
1	z_aitm4	SD09898
1	z_qna4	0.3
1	z_aitm5
1	z_qna5
1	z_aitm6
1	z_qna6
1	Right_od z_aitm
1	Right_od z_qna
1	Right_z_aitm
1	Right_z_qna
1	Right_z_aitm2
1	Right_z_qna2
2	od z_ritm	SD04567
2	od z_aitm	SD33358
2	od z_qna	1
2	z_aitm	SD09111
2	z_qna	1
2	z_aitm2	SD08111
2	z_qna2	1
2	z_aitm3	DG00790
2	z_qna3	1
2	z_aitm4	SD09899
2	z_qna4	0.25
2	z_aitm5	SD07777
2	z_qna5	1
2	z_aitm6
2	z_qna6
2	Right_od z_aitm
2	Right_od z_qna
2	Right_z_aitm
2	Right_z_qna
2	Right_z_aitm2
2	Right_z_qna2

[Clifford_Coon]

@Divyajyothi7 

This should work:

Happy Solving ;-)

 

[flying008]

Hi, @Divyajyothi7 

Another way for you: 

Input				Output
RecordID	Name	Value		RecordID	Name	Value
1	od z_ritm	SD04567		1	od z_ritm	SD04567
1	od z_aitm	SD33358		1	od z_aitm	SD33358
1	od z_qna	1		1	od z_qna	1
1	z_aitm	SD09111		1	z_aitm	SD09111
1	z_qna	1		1	z_qna	1
1	z_aitm2	SD08111		1	z_aitm2	SD08111
1	z_qna2	1		1	z_qna2	1
1	z_aitm3	DG00790		1	z_aitm3	DG00790
1	z_qna3	1		1	z_qna3	1
1	z_aitm4			1	z_aitm4	SD09898
1	z_qna4			1	z_qna4	0.3
1	z_aitm5			1	z_aitm5
1	z_qna5			1	z_qna5
1	z_aitm6			1	z_aitm6
1	z_qna6			1	z_qna6
1	Right_od z_aitm	SD09898		1	Right_od z_aitm
1	Right_od z_qna	0.3		1	Right_od z_qna
1	Right_z_aitm			1	Right_z_aitm
1	Right_z_qna			1	Right_z_qna
1	Right_z_aitm2			1	Right_z_aitm2
1	Right_z_qna2			1	Right_z_qna2
2	od z_ritm	SD04567		2	od z_ritm	SD04567
2	od z_aitm	SD33358		2	od z_aitm	SD33358
2	od z_qna	1		2	od z_qna	1
2	z_aitm	SD09111		2	z_aitm	SD09111
2	z_qna	1		2	z_qna	1
2	z_aitm2	SD08111		2	z_aitm2	SD08111
2	z_qna2	1		2	z_qna2	1
2	z_aitm3	DG00790		2	z_aitm3	DG00790
2	z_qna3	1		2	z_qna3	1
2	z_aitm4			2	z_aitm4	SD09899
2	z_qna4			2	z_qna4	0.25
2	z_aitm5			2	z_aitm5	SD07777
2	z_qna5			2	z_qna5	1
2	z_aitm6			2	z_aitm6
2	z_qna6			2	z_qna6
2	Right_od z_aitm	SD09899		2	Right_od z_aitm
2	Right_od z_qna	0.25		2	Right_od z_qna
2	Right_z_aitm	SD07777		2	Right_z_aitm
2	Right_z_qna	1		2	Right_z_qna
2	Right_z_aitm2			2	Right_z_aitm2
2	Right_z_qna2			2	Right_z_qna2

[Divyajyothi7]

did you take unique configuration for tile tool

on what basics you have joined the both outputs

[flying008]

Hi, @Divyajyothi7 

Yep, as your said , Tile by unique method, Join by tile position number.

*****

If help you get your want, please mark it as a solution and give a like for share more.

[Divyajyothi7]

Could you please share the file or show steps

[flying008 · Accepted solution]

Hi, @Divyajyothi7