TOPIC: filtering for drop down menus?

I am trying to get the selections for a drop down menu to populate using only choices that are sourced from a previous question that is a Multiple Short Text question.

The catch is that the previous question has 7 sub questions, but respondents don't have to answer all of the sub questions, (in my case the subquestions are just asking for a list of people on a team, and it could be anywhere from 2-7 people)

I can get the drop down to populate with all 7 answers, but I don't want it to show blank answers as a possible option if the team has fewer than 7 players. If only 4 people are on their team, I want the drop down menu in the latter question to only display those 4 names to select from.

Alternately I tried using an array with radio buttons and having the players names as the cumn headings, but I have learned that Limesurvey currently does not allow filtering array columns.

Oh! Sorry! I just called it Q2 for the sake of simplicity in the example. In the survey the first question where respondent list team mates is QID 2 and the question that I'm trying to make a drop down for is QID 110 if that helps.

All the other mandatory questions in between are irrelevant to QID 110, and do not affect QID 2

Okay, lets point out for other readers that you are using INSERTANS or Expression Manager to pipe the answer values from a multiple-short-text into the options of a drop-down and into the headers of an array.

Given that the drop-down and array questions are on following pages, we can use JavaScript to "filter" all empty drop-down options and array columns. Here are solutions for both question types.