If I only have one column containing the product names, how do
I pull in the name of the product that does not have either a "sub-product"
or is named "sub-product;1" (i.e. Product B;1, Product E;1 Product F;1).

In other words, I only want to pull in the following product names from my
master list below:
Product A
Product B;1
Product C
Product D
Product E;1
Product F;1
Product G

Master List:
Product A
Product B;1
Product B;2
Product B;3
Product C
Product D
Product E;1
Product E;2
Product E;3
Product F;1
Product F;2
Product G
Product H;2