here is the input that I have
| Job Start Date | well API Number | number of fracturing job opearations on the well | Total Base Water Volume (gallon) |
| 1/9/2018 | 1107200500001 | 2 | 31710 |
| 3/13/2018 | 1107200500001 | 2 | 59678 |
| 12/18/2014 | 1107203940000 | 2 | 93326 |
| 2/18/2015 | 1107203940000 | 2 | 93238 |
| 1/16/2015 | 1107204000000 | 2 | 96432 |
| 2/22/2016 | 1107204000000 | 2 | 42000 |
| 5/29/2015 | 1107204150000 | 2 | 47124 |
| 2/8/2016 | 1107204150000 | 2 | 50000 |
| 4/12/2013 | 3023106750000 | 2 | 8555904 |
| 4/15/2013 | 3023106750000 | 2 | 8737134 |
what i am trying to output is this
| Job Start Date | well API Number | number of fracturing job opearations on the well | Total Base Water Volume (gallon) | | | |
| 3/13/2018 | 1107200500001 | 2 | 59678 | | | |
| 2/18/2015 | 1107203940000 | 2 | 93238 | | | |
| 2/22/2016 | 1107204000000 | 2 | 42000 | | | |
| 2/22/2016 | 1107204000000 | 2 | 42000 | | | |
| 4/15/2013 | 3023106750000 | 2 | 8737134 | | | |
in order to do this I need the software to include ( well API number) that appears in the second date and exclude the first appearance.
thank you.
