Multi Row Formula

[Divyajyothi7]

Hi

I have following dataset, in the value column I would like to move up the values when ever it is null

Ex of data:

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: In the value column , whenever their is Null, it should be filled

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

[binuacs · Accepted solution]

@Divyajyothi7 One way of doing this