Forum Discussion
Solved
Power Query Challenge for you M Ninjas
I would like a query or function that will append every column in a table into a single list with dups removed. The names and number of columns is random so the solution needs to be dynamic.
How about:
List.Distinct(List.Union(Table.ToColumns(Tabel1)))
(This is the entire query code)
How about:
List.Distinct(List.Union(Table.ToColumns(Tabel1)))
(This is the entire query code)
This is pretty awesome. Is it possible to transpose the list so that the column headers remain and we still get distinct values for each column?