I have a zip code table that is used to assign sales hierarchies in my CRM. The table is set up with a range of zip codes / record rather than a singular zip code.
Capture Columns.JPG
I need to recreate this file to be one record for each zip code for use outside our CRM.
so the above would look like this
After.JPG
I had another sign on here which I had trouble getting in to, it's been years, but someone here had taken the file placed in the formulas and sent back the solution. Somehow the original file got corrupted by someone, and now I have lost the solution.
Note: I need to return all the fields above with the correct zip codes..
Bookmarks