I am trying to combined data in a csv file. The data looks like:
What I am looking for is the deletion of the 2nd column, and then for all the rows who are the same in the first field, a sum of the 3rd and 4th fields. There could be 1 to 4 rows with the same data in field 1. Output should look like.
If this were columns I think I could do it, but since it's rows I'm not sure of the SQL.