I would like the attached "JE-Postal-Heat-Map" to be auto populated by uploading the attached report "postal-codes-raw".
In the report "JE-Postal-Heat-Map" you don't have to worry about populating Columns K to Q. Below is what I would like populated.
The postal codes in "JE-Postal-Heat-Map" should be matched up with the postal codes in "postal-codes-raw" and the information that I am looking to populate is ;
- Total Dr's (restaurants) in each postal code
- How many of the top 8 cuisines are located in each postal code
In the "postal-codes-raw" report there are no cuisine headers like there are in "JE-Postal-Heat-Map". There is just cuisines Id's in the report. Below is each ID matched up with the correct cuisine I would like to show;
27 - Italian
28 - Greek
30 - Thai
31 - Indian
33 - Chinese
35 - Japanese
51 - Middle Eastern
64 - Pizza
In the "JE-Postal-Heat-Map" file there are also tabs broken down by which postal codes are in each region. I would like these populated as well. If we could have 1 upload form that would do all the populating, that would be ideal!
Let me know if you have any questions!