How to fill down blank rows using Arrayformula in Google Sheets

Assuming you have data in Column A, a list of products but it has some blank rows in between and you want to fill them down with product name itself. Let’s see the below example How to fill down blank rows using Arrayformula in Google Sheets

fill down blank rows in google sheets

Formula:

=ARRAYFORMULA(VLOOKUP(ROW(A2:A), FILTER({ROW(A2:A), A2:A}, A2:A <> ""), 2))

How to fill down blank rows using Arrayformula in Google Sheets

Read More:

COMMENTS