Hi Everyone,
I'm trying to organize my data so that it can be used in a dependent dropdown list.
I can't figure out how to do this. I can't do it manually because there are 100+ rows that need to be converted. I've tried transposing it, as well as creating a pivot table, but neither option...