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.