Hi everybody
I have question that I hope you can help with
Below you can find an example of what I need .
I need the code for command " İf there is two different type for the same id use type "Yes" and "if there is only one type written use the written type"
Example:
ID Type Weight Data Weight*Data
--- ------ --------- --------- ------------------
1 No 120 1 120
1 Yes 120 5 610
2 No 100 2.1 210
3 No 80 3.4 272
4 No 30 5 150
4 Yes 30 2.7 81
Expected result :
ID Type Weight Data Weight*Data
--- ------ --------- --------- ------------------
1 Yes 120 5 610
2 No 100 2.1 210
3 No 80 3.4 272
4 Yes 30 2.7 81
Thanks
