How to merge rows and sum them?
How can we merge rows of a table as shown below:XY STATE_1 1 STATE_1 6896 STATE_1 2 STATE_2 7 STATE_1 3 STATE_3 22 STATE_2 4 STATE_4 861 STATE_2 3 STATE_2 9494 STATE_3 2 STATE_1 37412 STATE_3 5 STATE_2 4 STATE_3 10 STATE_3 18 STATE_3 5 STATE_4 353 STATE_4 576 STATE_2 9494 STATE_4 33 STATE_1 3737 STATE_4 25 STATE_2 44 STATE_4 97 STATE_4 54 STATE_4 76 STATE_2 94 STATE_1 37 ST...
vince_faller