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! 😁
