Create a list from one column excluding values from another

Let me guess, you got your inspiration from Chris Webb's BI Blog: The List.* M Functions And The equationCriteria Argument Chris Webb's BI Blog (crossjoin.co.uk)  ?

let
    Source = {"Apples", "Zebras", "Bananas", "Veggies"},
    Select = List.Select(Source, each Table.RowCount(Table.SelectRows(QueryA, (k)=> Text.StartsWith( _ ,k[Column1])))=0)
in
    Select

let
  QueryB = {"Apples", "Zebras", "Bananas", "Veggies", "Pears", "Pea"}, 
  Source = #table({"Text"}, {{"App"}, {"Pe"}, {"Ban"}, {"All Others"}}), 
  #"Added Custom" = Table.AddColumn(
    Source, 
    "Column list", 
    (m) =>
      if m[Text] = "All Others" then
        List.Select(
          QueryB, 
          each Table.RowCount(Table.SelectRows(Source, (k) => Text.StartsWith(_, k[Text]))) = 0
        )
      else
        List.Select(QueryB, each Text.StartsWith(_, m[Text]))
  )
in
  #"Added Custom"