I am making a worksheet where the some cells may have multiple data values. Is there any way to have multiple values added to a single cell while retaining the ability to analyze the data after.

As an example, a petstore owner wants to create a waitlist database of potential customers who are waiting for certain breeds of puppies to become available. Some customers are only willing to buy a single breed of dog, but others would be willing to buy any number of breeds if they were to come available. Is there any way to input one or more values into a single "breed" field?

Thanks for any and all ideas!