Increment value of column

[Ferdinand_CUNY]

Hello all,

I have a source with this structure

Date1 | ID | val1 | Val 2| Val 3

12/01 | 1 | 3 | 5 | 4

12/01 | 2 | 4 | 5 | 7

12/01 | 3 | 5 | 5 | 9

I would like obtain this structure below

Value is number of the column nuber of above

Date1 | Val1 | Val2 | Val3 | Val4 | Val5| Val6 | Val7 | Val8 | Val9

12/01 | 0 |0 | 1 | 2 |4 |0 |1 | 0 | 1

How I can implement this?

[Prakhar1]

Could you also explain the logic you are trying to implement ?

[Ferdinand_CUNY]

It's to knwo the value the most popular