I need to merge records with the same PIN, and populate the null fields with values if they exist. The highlighted ones in the image are what I'm talking about.
This is just a test run; for the final product I will have 2,000+ records and 14 additional fields, instead of 4.
Does anyone know a good workflow to accomplish this?
If my description is not clear enough, this is what I need.
No more duplicate records, each parcel should have one record, and PIN 35.00071.01 (the first highlighted record) should read:
P12_acres: 79 | P12_amount: 10666 | P17_acres: 160 | P17_amount: 24000