I have a table of Census Blocks linked to ZIP4 values. I'm trying to create another table getting the unique ZIP4 values associated with each Census Block.
I've tried using the Frequency, and Summary Statistics tool. These give me what I need, but the ZIP4 values are all added up, I need them separately.
Would using Pivot Tables get me what I need?
Using ArcMap 10.2.2, all extensions.