How to use FILTER to return a range with no blanks

Question

I have one sheet called 'Recetas' which has as first row a list of names. There are some blank cells between each one.

In my main sheet I want to generate a range with those names without the blank spaces. I have tried to use =FILTER(ARRAYFORMULA(Recetas!$1:$1), ARRAYFORMULA(NOT(ISBLANK(Recetas!$1:$1)))) but it displays an #ERROR! saying there is an issue with the formula.

As the documentation says, the first argument should be a range and the second one should be a column/row or in my case an ARRAYFORMULA.

I have checked both arguments in isolation and both work but when I use them in the formula, it doesn't work and the error message doesn't specify what is the problem.

Answer 1

Can you try:

=torow(Recetas!1:1;1)

• could be your sheet locale uses semicolon convention