Filtering stacked ranges

[RonOliver]

Hi!

I have three ranges in Sheet1 with personal information (names, phone numbers, etc.) that I want to cast into one list in a different sheet while filtering out blank rows. I have devised this formula:
=FILTER(VSTACK(Sheet1!A9:G85,Sheet1!A89:G135,Sheet1!A149:G170),VSTACK(Sheet1!A9:G85,Sheet1!A89:G135,Sheet1!A149:G170)<>"")

These ranges are fixed, although some rows in the ranges will be blank or will contain IF formulas returning "". I have tried many different variations of this, but I'm constantly getting a VALUE error. What am I doing wrong? Would I need to change the formula altogether?

Appreciate your help!

 

[felixstraube]

You have to filter with only one column at a time.
you could do something like this:

=LET(d, VSTACK(Sheet1!A9:G85,Sheet1!A89:G135,Sheet1!A149:G170),
FILTER(d, CHOOSECOLS(d, 1)<>"")
)

 

[RonOliver]

You have to filter with only one column at a time.
you could do something like this:

=LET(d, VSTACK(Sheet1!A9:G85,Sheet1!A89:G135,Sheet1!A149:G170),
FILTER(d, CHOOSECOLS(d, 1)<>"")
)

This can work. Thanks very much!