Create a table, from others with unique value

[Scarthart]

Good afternoon, what I want to do is that from 12 tables it takes only one column and shows me only the unique values

This would be the column that I would like to combine with the other tables that are 12

[lbendlin · Accepted solution]

You could do something like 

DISTINCT(
UNION(
SELECTCOLUMNS(from table 1),
SELECTCOLUMNS(from table 2),
...
)
)

But it would be much simpler if you had a single table in Power Query and do a deduplication there.