I have a list that contains 2 columns. Column A is the group name and Column
B is the members of that group. Therefore, Column A is repeating for each
entry in Column B.

I would like to be able to leave the duplicate entries in Column A blank and
just create a list (for use as validation on another sheet), omitting all the
blanks.

Is this possible?

Ex:

GROUP MEMBERS
Admin John
Sue
Carol
Users Joe
Missy
Amy
Managers Robert
Deborah


I want to be able to have a validation list that contains Admin, Users,
Managers without blanks.