Dealing with multiple parcels in same column

Discussion created by naseefc on Nov 2, 2012
Latest reply on Nov 4, 2012 by m.gasior
I have a table that looks like this:

features_name      parcel_no
a                        123
b                        145
c                        236

So my plan is to join this table to my parcel shapefile and then I will have my features geocoded. Easy.

But here is the problem, sometimes I have this

features_name      parcel_no
a                        123, 346, 307

Now I could go through the excel file and manually create three records for feature a and give it the three parcel numbers, but I am wondering if there is an easier, more efficient way to handle this task. Once I have it all geocoded I plan to run a dissolve by feature name so that all parcels related to feature a are combined anyway.

Thanks for the help.