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:

enter image description here

CodePudding user response:

For column B, put in C1

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

enter image description here

  • Related