Multi Row Formula stop filling down at empty row

[lizhaozhi]

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

[atcodedog05 · Accepted solution]

Hi @lizhaozhi 

Here is how you can do it.

Workflow:

Hope this helps : )