Listing data from multiple tables in the "enumlist" column

[Pointer]

Listing data from multiple tables in the “enumlist” column is done?

for example

SELECT(Table 1[Name], [Location]=[_THISROW].[Location]) =>> result: (A, B, C)

SELECT(Table 2[Name], [Location]=[_THISROW].[Location]) =>> result: (X, Y, Z)

SELECT(Table 3[Name], [Location]=[_THISROW].[Location]) =>> result:(U, V, W)

Valid_if how should I use a formula, to get the following result?

Enumlist (A, B, C, X, Y, Z,U, V, W)