Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more

Use for questions about the use of the Google Sheets built-in function ARRAYFORMULA.

Google Sheets has a the built-in function ARRAYFORMULA which

Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays

source

It could be used together with .