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.
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.