I have a points layer of specimen samples. They have a field called "RESULT" which is a string field containing the results of a test, "Positive" and "Negative"(you can only see negative in the pic but trust me they're there).
I would like to determine how many positives and negatives are in each county, with each county having a COUNT_POSITIVES and COUNT_NEGATIVES column.
I've tried the Summary Statistics, Table Intersect, Pivot, and Frequency tools in ArcToolBox. The closest I've gotten is the output from the Frequency Tool:
but I'd like to "unstack" the results column so that for each county the table has a column for negatives and positives with their respective counts by county.
You can do this in about 2 seconds in Excel. Is there an easy way to do this in ArcGIS that I'm missing? This is the only response I could find but the case field in summary statistics won't work due my fields being strings (Calculate frequency of a attribute field per polygon)