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] | 1 |
1 | 2 |
[Null] | 2 |
[Null] | 2 |
1 | 3 |
[Null] | 3 |
[Null] | 3 |
1 | 4 |
[Null] | 4 |
[Null] | 4 |
[Null] | 4 |
[Null] | 4 |
1 | 5 |
[Null] | 5 |
[Null] | 5 |
1 | 6 |
[Null] | 6 |
Solved! Go to Solution.
@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.
Thank you Qiu, Thank you binuacs!
They both worked.
Really appreciate it! 😁