I am using power query to pull in around 20 columns of data. One of the columns is a players name. The other columns are various seasonal stats for that player. Instead of the raw stats which is currently in each column, I want the person leading each stat to have a 1 in that column. The player that has the second best statistic in that column will have a 2..........
So, in the end, instead of seeing the actual stat in the 20 total columns, I will see the players name in the first column and their ranking in each of the following columns.

Is there an easy way to accomplish this in power query?

Now:
Name Avg OBA BB K%
Smith .234 .321 .23 .13
Lane .221 .275 .25 .15
Frank .300 .145 .20 .14

End Result:
Name Avg OBA BB K%
Smith 2 1 2 3
Lane 3 2 1 1
Frank 1 3 3 2