1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Categorizing rows by text

So, I’ve got a number of rows that I’d like to categorize by text in a single column.

Let’s say the rows are people’s names, and the column id like to use to categorize them is their favorite food. One person says “sushi and pizza,” while another says “pizza and spaghetti” and eight other things. There are a variety of responses, and not everyone gives the same number of responses.

How can I set that up so that pizza, sushi, spaghetti, etc. are distinct and filterable and maybe even sortable? I don’t want to have to have a “pizza” and “sushi” and “spaghetti” column. And I know if I just list their favorite foods (e.g., “pizza, spaghetti, hot dogs, hamburgers”), I’ll have to remember to type the combination in the same order to make it more usable if it’s just plain text, and then I’ll have to search by typing in words, rather than having filterable results.

Any help is appreciated!

submitted by /u/andyt563
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#pizza
#text
#sushi
#favorite food
#categorizing
#filterable
#spaghetti
#distinct
#single column
#sortable
#responses
#rows
#results
#data organization
#plain text
#combination