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.
User | Count |
---|---|
109 | |
89 | |
77 | |
54 | |
40 |