topic Re: How to convert into this table? in Data Management Questions https://community.esri.com/t5/data-management-questions/how-to-convert-into-this-table/m-p/749898#M42181 <HTML><HEAD></HEAD><BODY><P>Oh yes! Pivot table is what I wanted. Thanks Michael and Dan <IMG src="https://community.esri.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 01 Jul 2016 11:38:53 GMT SalmanAhmed3 2016-07-01T11:38:53Z How to convert into this table? https://community.esri.com/t5/data-management-questions/how-to-convert-into-this-table/m-p/749895#M42178 <HTML><HEAD></HEAD><BODY><P><BR />Is there anyway in ArcGIS to convert the first table into the second one? I thought about it a lot but couldn't get the idea how to do even using python (I'm a python beginner).</P><P></P><P><IMG __jive_id="210142" alt="1.jpg" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/210142_1.jpg" style="height: auto;" /></P><P></P><P><IMG __jive_id="210167" alt="2.jpg" class="image-2 jive-image" src="https://community.esri.com/legacyfs/online/210167_2.jpg" style="width: 620px; height: 34px;" /></P></BODY></HTML> Thu, 30 Jun 2016 15:24:43 GMT https://community.esri.com/t5/data-management-questions/how-to-convert-into-this-table/m-p/749895#M42178 SalmanAhmed3 2016-06-30T15:24:43Z Re: How to convert into this table? https://community.esri.com/t5/data-management-questions/how-to-convert-into-this-table/m-p/749896#M42179 <HTML><HEAD></HEAD><BODY><P>Try looking into Pivot Tables</P><P><A href="http://resources.esri.com/help/9.3/arcgisengine/java/gp_toolref/data_management_tools/pivot_table_data_management_.htm">http://resources.esri.com/help/9.3/arcgisengine/java/gp_toolref/data_management_tools/pivot_table_data_management_.htm</A></P></BODY></HTML> Thu, 30 Jun 2016 16:13:58 GMT https://community.esri.com/t5/data-management-questions/how-to-convert-into-this-table/m-p/749896#M42179 MichaelMiller2 2016-06-30T16:13:58Z Re: How to convert into this table? https://community.esri.com/t5/data-management-questions/how-to-convert-into-this-table/m-p/749897#M42180 <HTML><HEAD></HEAD><BODY><P>more recent versions of the pivot table help (ie for 10.4 and 10.3) can be found here</P><P><A href="http://desktop.arcgis.com/en/arcmap/10.3/tools/data-management-toolbox/pivot-table.htm" title="http://desktop.arcgis.com/en/arcmap/10.3/tools/data-management-toolbox/pivot-table.htm">Pivot Table—Help | ArcGIS for Desktop</A>&nbsp; and for </P><P>ArcGIS Pro&nbsp; <A href="https://pro.arcgis.com/en/pro-app/tool-reference/data-management/pivot-table.htm" title="https://pro.arcgis.com/en/pro-app/tool-reference/data-management/pivot-table.htm">Pivot Table—Data Management toolbox | ArcGIS for Desktop</A> </P></BODY></HTML> Fri, 01 Jul 2016 00:47:16 GMT https://community.esri.com/t5/data-management-questions/how-to-convert-into-this-table/m-p/749897#M42180 DanPatterson_Retired 2016-07-01T00:47:16Z Re: How to convert into this table? https://community.esri.com/t5/data-management-questions/how-to-convert-into-this-table/m-p/749898#M42181 <HTML><HEAD></HEAD><BODY><P>Oh yes! Pivot table is what I wanted. Thanks Michael and Dan <IMG src="https://community.esri.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 01 Jul 2016 11:38:53 GMT https://community.esri.com/t5/data-management-questions/how-to-convert-into-this-table/m-p/749898#M42181 SalmanAhmed3 2016-07-01T11:38:53Z