I have a table like this:
| 1 | 2 | 3 |
| 1 | ||
| 1 | 2 | 3 |
| 1 | ||
| 1 | 2 | 3 |
| 1 |
Desired output:
| 1 | 2 | 3 |
| 1 | 2 | 3 |
| 1 | 2 | 3 |
| 1 | 2 | 3 |
| 1 | 2 | 3 |
| 1 | 2 | 3 |
Using Multi Row Formula to fill down the 2's and 3's, how do I make it stop at the blank lines? This is what I'm getting currently:
| 1 | 2 | 3 |
| 1 | 2 | 3 |
| 2 | 3 | |
| 1 | 2 | 3 |
| 1 | 2 | 3 |
| 2 | 3 | |
| 1 | 2 | 3 |
| 1 | 2 | 3 |
Solved! Go to Solution.
