Thanks so much. Its interesting to note that ArcGIS Pro has a pivot table.
The result after applying the pivot table tool is quite close to what I want, but not exactly.
As shown in the picture, I have the count for each State and the corresponding counts per operator.
I'd like to advance by ranking operators relative to their performance in each state. So I'd like to have columns for First_Operator, Second_Operator, Third_Operator, and Forth_Operator. So for Abia State, under First Operator, it should be MTN since it obviously has the highest number of towers, and the second_operator will be Airtel (the result should be similar to the picture below).
I hope I have been able to provide sufficient clarity on the problem.
Thank you.