Combine duplicate rows but keep class information?

by Tim G   Last Updated September 30, 2019 16:22 PM

I'm stuck trying to figure out how to avoid combining and deleting duplicate values manually. I'm working with parcel data, and based on some property information, each parcel is either in group a, b, c, multiple groups, or no groups at all. I had to do some select by location processing to get the lists of the parcels for each group.

I want to create a master list that combines the records from each group, removes duplicates, but still retains the group information. For example, if I had:

John Doe, 123 Main Street, Group A
John Doe, 123 Main Street, Group B
John Doe, 123 Main Street, Group C
Mary Smith, 321 Pleasant Street, Group B
Mary Smith 321 Pleasant Street, Group C
Alex Jones, 111 Park Ave, Group C

I would want the output to be:

John Doe, 123 Main Street, Group A, Group B, Group C
Mary Smith, 321 Pleasant Street, Group B, Group C
Alex Jones, 111 Park Ave, Group C

I already created GROUP_1, GROUP_2, and GROUP_3 field in the respective attribute tables and have tried merge, union, append, and even some manual select by location add to selection and cannot figure it out for the life of me. Any help would be greatly appreciated.

Also, I have R, although I'm not great at it, so if this can't be done in ArcMap but can be done in R, that may be a workaround.



Related Questions


Dataframe data handling or SQL Query in ArcMap

Updated June 20, 2019 20:22 PM

Nationwide Floodplain Analysis

Updated April 13, 2017 21:22 PM

Storing and managing spatial data?

Updated June 28, 2017 17:22 PM

File Shortcuts For Datasets?

Updated June 08, 2017 00:22 AM