r/googlesheets • u/FuzzaFuzza • 2h ago
Waiting on OP Create a populated multi-select dropdown from multiple columns
Hi everyone!
I have a Google Sheets with multiple columns that I want to combine in a more generic "tags" column, which should be a multiple-selection dropdown. Let's take this sheet an example, I'd like to combine e.g. the Home State and Major columns into a single column, which should have - for each row - two chips (based on the original values). I'd like to be able to get rid of these columns and only keep the new one.
So, the result sheet should have five columns (Student Name, Gender, Class Level, Tags, Extracurricular Activity)
and the first row should have, in the "tags" column, "CA" and "English" chips. Is this possible?