New answers tagged

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) } )
user avatar
  • 5,824

Top 50 recent answers are included