I have a spreadsheet that has over 5400 rows of entries.
One of the columns is name of a vendor. We have many vendors listed and multiple times.
I am looking to see how can I extract the names of the vendors so that I can run a count function.

basically, I am looking to get all the entries from the sort drop down box into the spreadsheet.