Shell Programming and Scripting

name1_test          501
name 1 33            510
test2                              900
name1_test         300

name1_test      801
name 1 33            510
test2                              900

awk ' {
        $1 = $1
        $NF = ","$NF
        f1 = $0
        sub(/,.*/,x,f1)
        f2 = $0
        sub(/.*,/,x,f2)
        a[++i] = f1;
        b[++j] = f2;
        c[f1] = f2;
} END {
        for(k in c)
        {
                for(n=1; n<=i; n++)
                {
                        if(k == a[n])
                        {
                                t += b[n]
                        }
                }
                print k, t
                t = 0
        }
} ' file

awk 'NR==FNR{a[$1]+=$NF; next}a[$1]{$NF=a[$1]; print; delete a[$1]}' file file

$ awk '{tmp=$NF; NF--; Ar[$0]+=tmp} END {for (i in Ar) print i, Ar[i]}' file