Fill Empty Cells With The Same Value as Previous Cell in Google Sheet (Array Formula)

Question

I have a list of data that can be seen in this example:

https://docs.google.com/spreadsheets/d/1bRiupsmjfDRE9AgcM_5KJKAyxYKpQiMuyAGSoGaZYN0/edit?usp=sharing

Range A:B is the given data
Range D:E is the desired result

It is very easy to solve it without array formula. But Is there any array formula that can work it out? I need array formula so that i dont have to drag again and again when the data is added below.

user_5632629 · Answer

use:

=INDEX({A:A, IF(A:A="",, VLOOKUP(ROW(B:B), 
 IF(B:B<>"", {ROW(B:B), B:B}), 2))})

user_15019380 · Answer

For column B, put in C1

=ArrayFormula(lookup(row(B:B),row(B:B)/if(B:B<>"",1,0),B:B))

Fill Empty Cells With The Same Value as Previous Cell in Google Sheet (Array Formula)

2 Answers