New answers tagged filter
0
votes
Accepted
Filter from specified columns and display results into 1 column
Use { array expressions } to stack the data, like this:
=filter( { Data1!C4:C; Data2!C4:C }, { len(Data1!E4:E); len(Data2!E4:E) } )
- 5,824
Top 50 recent answers are included