Create duplicate points based off excel spreadsheet

Question

I work for a utilities company. All of our assets have unique IDs & names. Someone has asked me to create a heat map to show the location of our assets that have certain priorities of defects listed against them. They've sent the defect file through in an excel spreadsheet, and unfortunately there are some instances where one asset has 4 defects listed against it, each it's own separate line in excel.

Is there an easy way to duplicate only those points that have more than one defect listed against them, as some have two priority 3's and two priority 2's. So they would need to be displayed twice for each priority heat map.

Any suggestions, other than doing it manually (over 800 records), would be appreciated.

ElaineCollinson · Answer

Thank you all for the wonderful tips and feedback.

I realized I was overthinking it. I got the excel spreadsheet and used FME to link to our asset database and populated the excel spreadsheet with the coordinates of the assets. Put the spreadsheet into Pro and created points using the x, y.

lmott · Answer

Check out using a Pivot Table in excel to see which have more than 1 occurrence.

RTPL_AU · Answer

@RichardHowe  You're 100% correct - when it works 🤣
I've had so many instances where Pro (3.x) just doesn't want to make a join for some reason that I ended up doing things the hard way.  Sometimes a restart will make it join properly, other times nada. 
Often I can do the same join in ArcMap and it works - but then I don't have all the pretty symbologies......

@ElaineCollinson

A benefit of running Frequency is that you then have a quantitative value you can also use as a 'proper' indicator in a regular symbology; sometimes people want to compare two different periods or datasets and heatmaps are hard to make comparable much more than 'here bad, there good' 🙂