Hello, I have a dataset like this
| Multiplier |
| 0 |
| 0 |
| 0 |
| 0.75 |
| 0 |
| 0 |
| 0.5 |
| 0 |
I need to convert it to this:
| Multiplier |
| 0.75 |
| 0.75 |
| 0.75 |
| 0.75 |
| 0.5 |
| 0.5 |
| 0.5 |
| 0 |
Could anyone help suggest a formula please, tks
Solved! Go to Solution.
Hi @lolwat12345
Filling values upwards is trickier than filling down. For this I usually add a record ID, sort the data to reverse the order, do the multi-row, and sort back:
