AnsweredAssumed Answered

Merging rows of an Excel table in ArcMap

Question asked by scott.louque on Sep 16, 2020
Latest reply on Sep 16, 2020 by jborgion

I have a Hydrology feature which represents all the Hydrology in my community and was tasked with calculating the miles of all the ditches. However, the lines which represent the ditches are broken into segments. This was easy enough to do by exporting the attribute table out to a dbf file and then opening the .dbf file in Access to create the queries I needed and then export them out to Excel to perform the calculation. I just hid all the line segments so they wouldn't have so many rows in my table


Now that I have an Excel spreadsheet which contains the information I want, I would like to store it as a table in a file geodatabase. But when I load them into a file geodatabase, all the segments are not hidden anymore. I thought I would just be able to select the rows again in ArcMap and then use Merge under the Editor toolbar to merge all the segments together but Merge is not activated when I do this. Is there another way to accomplish what I am trying to do?