Quoted By:
I've got a pre-existing table that has data in the format of:
A C qeweq <data>
A C sdada <data>
A D zxczv <data>
A D uippo <data>
B C hjkkl <data>
B C sjkir <data>
B E iopeip <data>
B E jfdky8 <data>
B F 329rfju <data>
B F r239fj <data>
and so on.
I want the first drop down menu to be the list of unique strings from the first column. Then the second drop down menu to be the list of unique strings from the second column, but only the ones that are to the right of the option selected from the first list. And then I want the third drop down menu to be the list of unique strings from the third column, but only the ones that are to the right of the option selected from the second list. And I need the order of everything to be maintained.
I cannot for the life of me figure out how to do this. Spending time making new tables to make each list manually is not what I'm looking for. Pivot Tables seemed to be what I wanted for the intermediate step, but for some reason they automatically sort everything and I need the order of the table to be maintained. Custom sort lists do no good as a workaround there either.
I'm rather stumped. I can make a single drop down list of all ~200 items from the third column, but I'd really rather make it easier for other people to find and select the option they're looking for.
