I need help trying to fill down these rows based on another row that's filled with only 1s and Nulls: Site Desired Output[Null] 1 1[Null] 11 2[Null] 2[Null] 21 3[Null] 3[Null] 31 4[Null] 4[Null] 4[Null] 4[Null] 41 5[Null] 5[Null] 51 6[Null] 6

Increment by 1 based on another row

I need help trying to fill down these rows based on another row that's filled with only 1s and Nulls:

Datasets

@bleu One way of doing this with the multi-row formula tool

@bleu
We can use a Multi-Row formula tool for this purpose as below.
The first one will be zero so we can will replace it with a Formula tool.

@bleu One way of doing this with the multi-row formula tool

Thank you Qiu, Thank you binuacs!

They both worked.

Really appreciate it! 😁