Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved.
Learn more here!
Splitting the Range into Columns and Generating the AREA PIN CODE in incremental fashion and joining with Region/Rep Data and Summarizing would provide answer.
It could have been in split sentences, this is my first port on Community :).