A Sortable Unique List of Items Based on adjacent cell match

[matolibriyum]

=IFERROR(INDEX(inv!$D$1:$D$2500,SMALL(IF(INV!$A$1:$A$2500="VENDOR NAME",ROW(INV!$D$1:$D$2500)-ROW(INV!$A$1)+1),ROWS($A$1:A1))),"")

This has yielded the top down list results I want. It is searching in a table made from a power query to an online csv document that autopdates.

I have a I would like to populate the local table [sku] column with the unique list it finds in inv! column d based on it's match criteria in inv! column a.


I would also like to be able to sort my table and input manual criteria in some of the columns to make sorting and categorizing choices manually.