Hello

I need help with this work.

In particular I have a list of companies and to each company could correspond several rows.
It could happen that a company has several rows which correspond to the same location.
My work is doing something like that:

Starting from:

Apple Cupertino
Apple Cupertino
Apple San Francisco
Google San Francisco
Google London
Amazon Milan
Amazon Milan
Amazon Milan
Amazon Seattle

I should get something like this:

Apple Cupertino 2
Apple San Francisco 1
Google San Francesco 1
Google London 1
Amazon Milan 3
Amazon Seattle 1

In this way I can eliminate some rows without losing the information.