How to make my ARRAYFORMULA(A1 something else) to stop producing results after there are no more values in A1 column, eg. to skip blank values. By default it gives endlessly "something else".

Here is my demo sheet:

CodePudding user response：

You can try this formula =ARRAYFORMULA(IF(ISBLANK(A1:A),"",(A1:A B1:B))) if this works out for you.

Reference:

https://support.google.com/docs/answer/3093290?hl=en