How to perform actions on 'every column of a table' regardless of the number and name of the columns

[UsePowerBI]

Hello

How to perform actions on 'every column of a table' regardless of the number and name of the columns?

I would like for example:

1) get the unique values of each column

2) get the first give values of each column

etc

Thanks!

[UsePowerBI]

@ryan_mayu 

Please find below the source table and I want to output the following lists of unique values per column. Please note I want the solution to work regardless of the table and columns!

Col1	Col2	Col3
1	2	3
2	3	4
1	2	3
2	3	4

Col1

1

2

Col2

2

3

Col3

3

4

[ryan_mayu]

do you want to combine the columns to a new table?

[UsePowerBI]

@ryan_mayu yes or I may do additional transformations once I get these unique value lists, I thank you! 

[ryan_mayu]

@UsePowerBI 

i am not good at M. However, here is a workaround for you

[ryan_mayu]

could you pls provide the sample data and expected output?