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

Open chat
Talentnett Solutions
Hello,

How may I help you today!

Regards,
Umesh Agarwal
Contact - +91 - 7017544508
Email - umesh.agarwal@talentnett.com

Cool Tips and Tricks Directly Delivered in your Inbox. Subscribe to our Newsletter.

You have successfully subscribed to the newsletter

There was an error while trying to send your request. Please try again.

Talentnett will use the information you provide on this form to be in touch with you and to provide updates and marketing.