@rant You don't need a search for that/ or does not really matter duplicates you can use CSV Import.
You make your search that would return duplicate Items/Internal IDs, remove duplicate in Excel, save as CSV, import as Item Update -> Setting/Advanced Override Sublist, set the vendor to null...