How to convert into this table?

[SalmanAhmed3]

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).

[MichaelMiller2 · Accepted solution]

Try looking into Pivot Tables

http://resources.esri.com/help/9.3/arcgisengine/java/gp_toolref/data_management_tools/pivot_table_da...

[DanPatterson_Retired]

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

[SalmanAhmed3]

Oh yes! Pivot table is what I wanted. Thanks Michael and Dan