How to replace null value with previous row data

[Saravanan13]

Hello all,

I am looking to duplicate the values in previous row whenever there is a null value. Can anyone assist. I know we can use multi row field  formula but not getting the desired  output.

Input

accounts	Parent
1225	232323232
5454
545444
242323
43333
334343	5454545454
3433
343334
5454554
343333	4545454545
322222
423211
2431312	6767676767
344343
4544544
433433

Output-

accounts	Parent
1225	232323232
5454	232323232
545444	232323232
242323	232323232
43333	232323232
334343	5454545454
3433	5454545454
343334	5454545454
5454554	5454545454
343333	4545454545
322222	4545454545
423211	4545454545
2431312	6767676767
344343	6767676767
4544544	6767676767
433433	6767676767

[MilindG]

@Saravanan13  Does this work for you?

[CoG · Accepted solution]

In Multi Row Formula Tool, use the following formula:
IIF( IsNull( [Parent] ), [Row-1:Parent], [Parent] )

Hope this helps and Happy Solving!