There are approximately +1,000 rows, almost all of them have the same name but are split up with different lengths. I was looking for a way to combine the rows based on length and combine the names to a single name. So looking for a single row that keeps the name but has a total length. I have tried the dissolve function but I don't think that was working considering it was copying the lengths when setting it to SUM.

I do believe it is a standard license that is version 10.5. enter image description here

Looking for these to be all one attribute in a shapefile enter image description here

  • There are many ways to do this with such a small table. What have you tried? Please edit the question to specify the version and license level of ArcGIS in use and to use the image helper correctly to include your image inline with the Question. It
    – Vince
    Commented Mar 28, 2018 at 13:50
  • I did update the post, fairly certain its a standard license but the version is 10.5. I have tried the dissolve function but that just duplicated the lengths field.
    – user117485
    Commented Mar 28, 2018 at 15:21

2 Answers 2


The Dissolve tool is definitely the way to go here. The reason it isn't calculating the total length is because your data is in a shapefile. You must either load your data into a file geodatabase, or calculate the length manually.

One way to do this is by using the Calculate Geometry tool or field calculator. Of course, you'll need to ensure that your data is in a projected coordinate system, not a geographic coordinate system.


right click on the column header for NAME. Select Summarize. In the resulting dialogue box, expand the options for your length field. If the length field is numeric, you can select "sum" and click OK.

  • It is a shapefile that I am using, I edited the post with another picture. So this is really close to what I want, however, is there a way to make it as a shapefile layer. The picture kind of shows what I mean, I want them combined to a single attribute that can be selected.
    – user117485
    Commented Apr 4, 2018 at 0:14
  • Shapefiles don't automatically update a field for feature geometry lengths like feature classes do. So you'll have to calculate it yourself. Add a field to the shapefile (specify "DOUBLE" type), call it something like "length_m" for meters or "length_ft" for feet. then right click that field heading and select "calculate geometry" and let it rip.
    – Zipper1365
    Commented Apr 4, 2018 at 19:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.