I have joined corresponding Local Enterprise Partnerships table data into a polygon shapefile containing UK Local Authorities.
How do I Dissolve or Merge the the Local Authorities polygons by LEP_NAME as shown in the screenshot?
Ideally, I would like to retain the Local Authority attributes with the resultant merged polygons. I have zero scripting knowledge so am looking for a tool based solution.
Additional Note: When attempting to use the dissolve tool the LEP_NAME field is not available as shown above. The LEP attribute data was created in Excel, saved as CSV format and joined to the Local Authority polygon shapefile. There are duplicate IDENTIFI0 fields as shown in the other screenshot.