Community

Combining column into row based on unique ID

2889
1
08-17-2015 05:03 PM
RaviSingh2
by
New Contributor
‎08-17-2015 05:03 PM

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. enter image description here

I want it to look like this: Some thing like this enter image description here

0 Kudos
1 Reply
JoshuaBixby
by MVP Esteemed Contributor
MVP Esteemed Contributor
‎08-18-2015 05:54 AM

Check out the Pivot Table tool.