You can alphabetize data in an Excel spreadsheet by row or column using the "Sort" feature, or through the "Data" and "Home" tabs.

Excel Online supports sorting by multiple columns. How to sort by two columns Grouping is a common database task, and sorting by multiple columns is essentially the same thing.

If you wish to count the same or duplicate values in a column only once in Excel or the count of occurances of duplicate values, read this article.