I would like to quantify the percentage area covered by different categorical values (A, B, C, D, E, F, G) within each cell. The cells are defined by layer_1 while the categorical values are in layer_2.
Is there a specific tool or tool combination that I can use in ArcGIS to achieve this?
Hopefully the image gives a good example of what I mean.
I am looking at the spatial join tool + pivot tool to see if this can be done.
I am running ArcGIS 10.3.1 for Desktop (Advanced) with extensions for Spatial Analyst, XTools Pro and Geostatistical Analyst.