BEGIN {FS=", *"} {sum[$2]+=$1 } ! country[$2] && $3 != "" {country[$2] = $3} END { for ( k in sum ) { print sum[k] "," k "," country[k] } }