Given below is the data (Notice that some of the Ids are repeating) :
I want the output as follows:
| ID | Field1 | Field2 |
| 1 | 10 | -10 |
| 2 | 20 | -20 |
| 3 | 30 | 15 |
| 4 | 40 | 20 |
| 5 | 50 | 100 |
| 6 | 60 | 120 |
| 7 | 5 | |
| 8 | 5 | |
So basically I require a new filed that will represent data based on common ID as shown in above snip.
Thanking in advance.
Regards,
Chirag
