Hello,
I am trying to make a list of things appear in a dropdown list (like the data validation list) and show its subcategories in the same list for example:
Categories: Fruit, Vegitables
Sub-categories: Apple, Banana, Cucumber, Brocoli
Sub-sub-category: Red Delicious, Gala, Granny Smith
So the list would ideally like:
Vegitables > Cucumber
> Brocoli
Fruit > Banana
> Apple > Red Delicious
> Gala
> Granny Smith
I would like to avoid doing this in multiple columns, if this isn't possible is there a way to make a pop-up acheive the same goal?
Thanks!