I am new to using parcel data, I have been given a task to update a Feature class with a spreadsheet containing "new columns" to add to the data. The only problem is that they also added numerous new "records" as well.
For Example for each PID that is unique in the FC, the xls had 6+ records for that one PID. The client wants the dataset to have only 1 polygon for each PID, but to retain the 4 records for each.
I am at a loss how to do this. If I do a join I get 4 records of the same PID which is not what I want. Below is a look at the xls they sent. Yellow is to be added.
Any help would be appreciated.