You have 2 (or more) States for some stores, that is impossible, isn’t it? You should enter a store for every City.
If you explain more of the database maybe we could avise, but I think I would have:
- Brand field
- City field
- Name field: a Formula combining the Brand and City
So we would have:
- Johns Store (NYC)
- Johns Store (Los Angeles)
Even you could have Cities and States in separate Tables, and relate them with Linked Record field, so you shouldn’t have to enter the State every time. You will just need the City.
Also, you could have a separate Table for Brands, so you could have Counts, Averages, Sums, etc. of the Brands:
- A View ordered by number of stores
- A View ordered by number of products (if you would have that information, just an example )