topic Re: Combining column into row based on unique ID in Alabama GIS Users Questions https://community.esri.com/t5/alabama-gis-users-questions/combining-column-into-row-based-on-unique-id/m-p/789708#M7 <HTML><HEAD></HEAD><BODY><P>Check out the <A href="http://desktop.arcgis.com/en/desktop/latest/tools/data-management-toolbox/pivot-table.htm">Pivot Table </A>tool.</P></BODY></HTML> Tue, 18 Aug 2015 12:54:29 GMT JoshuaBixby 2015-08-18T12:54:29Z Combining column into row based on unique ID https://community.esri.com/t5/alabama-gis-users-questions/combining-column-into-row-based-on-unique-id/m-p/789707#M6 <HTML><HEAD></HEAD><BODY><P>How it can be done in Arcgis</P><P>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.</P><P>one row will only contain ColumnA and the other row will contain ColumnB. <A href="http://i.stack.imgur.com/ihARU.png"><IMG alt="enter image description here" class="jive-image" src="http://i.stack.imgur.com/ihARU.png" title="" /></A> </P><P>I want it to look like this: Some thing like this <A href="http://i.stack.imgur.com/ozf8Y.png"><IMG alt="enter image description here" class="jive-image" src="http://i.stack.imgur.com/ozf8Y.png" title="" /></A></P></BODY></HTML> Tue, 18 Aug 2015 00:03:34 GMT https://community.esri.com/t5/alabama-gis-users-questions/combining-column-into-row-based-on-unique-id/m-p/789707#M6 RaviSingh2 2015-08-18T00:03:34Z Re: Combining column into row based on unique ID https://community.esri.com/t5/alabama-gis-users-questions/combining-column-into-row-based-on-unique-id/m-p/789708#M7 <HTML><HEAD></HEAD><BODY><P>Check out the <A href="http://desktop.arcgis.com/en/desktop/latest/tools/data-management-toolbox/pivot-table.htm">Pivot Table </A>tool.</P></BODY></HTML> Tue, 18 Aug 2015 12:54:29 GMT https://community.esri.com/t5/alabama-gis-users-questions/combining-column-into-row-based-on-unique-id/m-p/789708#M7 JoshuaBixby 2015-08-18T12:54:29Z