Forum Discussion
Data organization for multiple vendors
I am trying to figure out how to organize by excel data based off of states and what general contarctors work in those states. I eventually want to create a map visual where I click on a state and t...
Thank you for your quick reply. For each contyractor, I ahve multiple states. How do I account for that on the excel sheet?
For the sake of keeping it organized and easier to manage in the future (and allow one-to-many relationships to work), I would do a table that is just a unique list of contractors (like the one above). Then make another table (third one now) that is something like "ServiceAreas" which will have one contractor & state per row, and it is ok to have multiple rows of the same contractor, one for each state they service.