Hi. I need to create these two columns in a separate sheet in Excel, called Requester Location and # of tickets. Please see below.

The data comes from a database on another sheet in Excel, and it contains a list of many locations and countries. I need a way to automatically insert the country/location, and then automatically populate how many times it appears in that column. See below.

\begin{tabular}{l|r|} \hline Requester Location & \# of tickets \\ \hline Unknown & \\ \hline London & 171 \\ \hline Syke & 154 \\ \hline Australia & 50 \\ \hline Partner & 16 \\ \hline EMEA & 14 \\ \hline South Africa & 13 \\ \hline Singapore & 12 \\ \hline China & 3 \\ \hline United Arab Emirates & 1 \\ \hline Alerts & 87 \end{tabular} Requester Location Alerts London Alerts London London