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

Categorizing rows by text

Our take

Categorizing rows by text in a single column can enhance your data management experience, especially when dealing with varied responses like favorite foods. Instead of creating separate columns for each food item, you can employ a method that allows for distinct, filterable, and sortable categories. By utilizing advanced spreadsheet functions, you can transform your text entries into manageable tags. This approach not only simplifies your data organization but also ensures that you can easily filter and sort based on individual preferences, enhancing usability and efficiency.

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]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with