Shell Programming and Scripting

1,0,100
1,1,150
2,0,200
2,1,250
3,0,300
3,1,350

1 100 150
2 200 250
3 300 350

awk -F, '
        {
                A[$1,$2] = $NF
                R[$1]
        }
        END {
                for ( k in R )
                        print k, A[k,0], A[k,1]
        }
' file

$ awk 'FNR==NR{A[$1] = A[$1] ? A[$1] OFS $3 : $1 OFS $3;next}($1 in A){print A[$1];delete A[$1]}' FS="," file{,}

1 100 150
2 200 250
3 300 350