How it can be done in Arcgis
I have a query that returns more than 2 lines per ID. I would like to be able to merge these into one single row, based on the ID.
one row will only contain ColumnA and the other row will contain ColumnB.
I want it to look like this: Some thing like this