I need some help here. So I need a function which imports selected columns from a different sheet out of which one of them contains a specified word but allows you to filter/ignore based on specified words
And here's the example sheet: https://docs.google.com/spreadsheets/d/1brWG_lbvqQUDT5x9ZGmxFKYUu6ByQ56SPi9Y9C21WBQ/edit#gid=1683245951
And this is the QUERY Function: =query(Sheet1!A:F, "SELECT A, B, C, D, E, F where (E contains 'Apple')")
Thank you for any help.