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
It could be used together with google-sheets.