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).
Try looking into Pivot Tables
http://resources.esri.com/help/9.3/arcgisengine/java/gp_toolref/data_management_tools/pivot_table_data_management_.htm
Oh yes! Pivot table is what I wanted. Thanks Michael and Dan
more recent versions of the pivot table help (ie for 10.4 and 10.3) can be found here
Pivot Table—Help | ArcGIS for Desktop and for
ArcGIS Pro Pivot Table—Data Management toolbox | ArcGIS for Desktop
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.