The easiest approach is to create the consolidated list elsewhere in a helper column (it could be hidden or placed somewhere out of the way) and then reference it as the source for the dropdown list. The consolidation could be done with a formula, but more details would be needed to advise further.