Multi-row formula: last row empty

[BautistaC888]

I´m trying to achieve the following with a multi-row formula, i want to know if that is possible.
Input:

Expected output:

Thank you.

[afv2688 · Accepted solution]

Hello @BautistaC888 ,

You can achieve it with a multi row formula:

IIF(!IsEmpty([Field2]), [Field2],
IIF([Row-1:New Field] !=[Row+1:Field2] AND !IsNull([Row+1:Field2]),Null(), 
IIF(IsEmpty([Field2]),[Row-1:New Field],[Field2])))

What the formula does is:

If there is some number on the other side it will take it,

If not and the one below has data leave it as null,

if not than take the one one row before

Edit: The data has been reordered due the checkbox on the goruping being clicked. There is no need to click it, you can leave it as it is (blank)

Regards

[Tyro_abc]

Hi @BautistaC888 

It seems I misunderstood the requirement earlier. I also used multi-row tool but just formula is slightly different. 

Regards

Arundhuti