Creating registery, filtering significant amounts of data per criteria.

I have a variety of vendors all of whom can service different locations and offer a variety of services. brief example below

Firm A | fakesville, crescent hill | Window Repairs, Drilling |

I am attempting to construct a registry that will allow hundreds of vendors to be filtered by both their location and service provided. I have looked and there appears to be no way to do this on a single sheet due to the standard filtering not handling more than one value per cell. Once filtered, the idea is that the firm along with the other cells with contact information are shown as well which is straight forward. All this data needs to be individually entered as well into the system still.

An additional issue with there are a state wide amount of locations (so values need to be able to be added regularly as new firms are added) and there are upwards of 50 service catagories.

This is for work so there is no scope for any vis basic coding to make filtering more responsive and I can't provide examples of the data being used due to the business nature.

I have done financial stuff before with excel but havnt done anything close to this since high school.

Cliffs

- have large amount of data to filter in two seperate categories
- have no clue what to do functionally

Thanks in advance.