Help with formula

I had the same job to do for a different goal, so I create a list of things to do to accomplish that mission.

I attached the file; this way you don't have to rename all 2000 cities, but it checks it with all the coordinates (which I assume are correct).

Columns in green are the columns you have normally.

Red column is the important one, it merges all the coordinates.

Blue columns are a copy of the green ones, but all datas in that columns are going to be displayed by a formula.

Column J checks if the coordinates are a duplicate, if that so, it leave the cell blank.

All the rest of the columns give something different than an empty cell only if the correspondant J cell is not empty (i.e.: if the row is not a duplicate).

Column P sum all the # of companies of the same coordinates in the first appear of the coordinates.

When you copypaste these formulas on all 2000 rows, you MUST copy columns J to P and paste them as valor (special paste), removing formulas. Then you can delete columns A to I and have a "new table" with some blank rows and the right sum of all the duplicates.

Then sort it or filter it to remove blank rows and the mission is accomplished!