filter function

[Tej92]

Hello all, i'm trying to bring all the data in one column from different columns.
from range A3:BN3 i have multiple filter functions that return values.
now i'd like all of those lists created by filter functions to be in one column, I've tried:
=filter(a3:bn3, a3:bn3 <> "") result: only the values at the top of the previous filter arrays in each column
=filter(a3:bn11, a3:bn11 <> "") result: #VALUE! error

any help will be greatly appreciated.

thank you

 

[SunnyAlv]

a3:bn11 <> ""

try to take just one column

like this

=filter(a3:bn11, a3:a11 <> "")

 

[FormR]

Hi, if I understand correctly you could try:

=TOCOL(A3:BN11,1,1)

 

[Peter_SSs]

Not sure how long your individual filter lists are so you may not need a number as big as I have used but try

=TOCOL(A3:BN10000,1,1)

 

[Tej92]

Thank you both for the reply.
It works well!! is there a way for it to ignore blanks in the first row? it is ignoring the blanks but not from a column that has nothing in it.
Edit: managed to ignore first blank of the column by using =FILTER(BO:BO,BO:BO <> "").

thanks again for the replies

 

[Peter_SSs]

A couple of other options

1. Build what you have done into a single formula
   

   =LET(tc,TOCOL(A3:BN10000,3,1),FILTER(tc,tc<>""))

   
   
2. Change your filter functions in row 3 to return NA() (or some other error) instead of "" if no filtered data exists - a simple example =FILTER(1,1>5,NA())
   and then use this in BO
   

   =TOCOL(A3:BN10000,3,1)