I am trying to import 2 columns from one sheet into another but trying to make sure I import only the cells from col2 when col1 has a value (all different values).
I imported my first column needed (column E) with the following formula =QUERY(IMPORTRANGE("LINK", "ALL Product Overview!E3:E"), "select Col1 where Col1 is not Null", 0)
Now I am trying to import my second col (column AY) but only the cells in Column AY when the same cell number in column E has value.
NOT
doesn't seem to provide much guidance.