Downloading cells from one Worksheet to another

Hi There,

I use this formula to extract some cells from Worksheet "Suppliers" based on a certain condition and load it into Worksheet "P&L". The formula works fine but I do not know how to modify it to exclude the duplicate values.

=IFERROR(INDEX(Table1[[Supplier Name]:[Product Type]],SMALL(IF((Table1[Product Type]=$A$9),ROW(Table1[Product Type])-1),ROWS($C$9:C9)),1),"")

Thank you

I have attached a sample file to demonstrate what I need to do. The duplicate cells are highlighted in Yellow, which I need to exclude. If the formula I use cannot be modified to do the job, I appreciate your input with another one.

Thank you