I am having an issue figuring out how to pivot on the following. I want to know the counts based on three columns.
Column one: Authorization Status with option active or closed
Column two: Unique ID
Column three: Agency
I would like the end result to be:
Authorization Status Agency 1 Agency 2
Active 5 10
Closed 20 30
Thank you