I'm trying to sort through data I'm inputting manually into a table and I'm wondering how to format a cell. I have a column for categories, and I want to assign one value to multiple categories. However, all it does is make the input into a new category. In my A column, I have a note. In my B column, I have the category that is assigned to that note. I am trying to assign multiple categories to a few of the notes, but it's not working how I intend. For example, one of my notes is "Use bulletin and mail from leadership in CDS for positive messaging and general resort/area updates" and the category is "Employees". The next note is "Put two-ply toilet paper in all Resort restrooms" and that category is "Resort 1". However, I have a note that applies to two categories: "Resort 1" and "Resort 2". What do I put into the cell that allows me to assign both of those categories, and filter them if I need to, instead of it creating a new category that just says "Resort 1, Resort 2"?
