On a Google Sheet, I want to have a dropdown list of options to choose from. However, these options are split into different sections and so I would need to select multiple sets of data. I can get the dropdown to work if I just do
But this is a problem because then the dropdown includes some titles which I don't want as options. However, If I try to do something like
It doesn't work. So Is there a way I can get a dropdown to use multiple sets of data?