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

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

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

Time：03-29

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

CodePudding user response：

For column B, put in C1

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