How to make the formula "bulk"?

Question

Google Sheets

Good afternoon. Such a task often arises - there is data in column A , and some kind of function on them in column B , for example
=GoogleTranslate(A1;"en";"ru")
It is not known in advance how many rows there will be in column A , so for convenience and beauty I usually do this:
=ЕСЛИ(A1<>"";GoogleTranslate(A1;"en";"ru");"")
the end of the table, to the entire column B .
Actually, the question is: how to avoid spreading all this and write a mass formula in B1 , like the one that gives the filter or importrange function ?
I often work with Google spreadsheets, but here I can’t think of something from a swoop.

Answer 1

No way. There are formulas that support arrays and that are supported in arrays. And there are people like this one.