In the attached file, I created a list in columns A and B. I then imported them to Power Query and merged them with a space separator. I then closed them to a table in column D. I then created a data validation in 1F for the values in Column D. I then added values to Column A and B. Clicked on Data Refresh All and the table in Column D is updated. The data validation is also updated in Column F.

Attached Files

PQ Merge Data Validation.xlsx (16.8 KB, 0 views)

__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2505