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 |
---|---|
108 | |
84 | |
76 | |
54 | |
40 |