I am using ArcGIS Pro and I am working with road data where the road is divided into segments. Each segment is listed as individual records in the attribute table. For example, there are 3 records (segments) for RoadNumber 1003. Not only am I wanting to join the 3 segments into 1 record withing the original attribute table, I am also wanting the field ‘seglength’ of the combined record to give the sum of the 3 segments. Is this possible and if so, would you please explain the steps to achieve these resulrts? I greatly appreciate it.
This is the screenshot of the table:
This is what I was hoping to do (I'm nor sure what happens in the final two columns)