Using UNIQUE and FILTER in a formula

[bienvenu]

I am trying to extract unique values from two columns of data and output them into one column. Can anyone tell me why this formula doesnt work?

=UNIQUE({FILTER(A1:A7,A1:A7<>""),FILTER(B1:B7,B1:B7<>"")})

 

[Fluff]

You cannot use arrays like that, how about

=LET(a,TOCOL(A1:B7,,1),UNIQUE(FILTER(a,a<>"")))

 

[bienvenu]

You cannot use arrays like that, how about

=LET(a,TOCOL(A1:B7,,1),UNIQUE(FILTER(a,a<>"")))

Works like a charm...I've no idea what LET and TOCOL are....but that's very helpful, thank you

 

[Fluff]

You're welcome & thanks for the feedback.