change groupby to titles from vendorid