Shell Programming and Scripting

ABC 200 400 2.4 5.6
ABC 410 299 12  1.5
XYZ 4 5 6 7
MNO 22 40 30 70
MNO 47 55 80 150

ABC 410 400 12 5.6
XYZ 4 5 6 7
MNO 47 55 80 150

awk '
        !( $1 in A ) {
                A[$1] = $0
                next
        }
        ( $1 in A ) {
                n = split ( A[$1], R )
                for ( i = 2; i <= n; i++ )
                {
                        R[i] = R[i] > $i ? R[i] : $i
                        s = s ? s FS R[i] : R[i]
                }
                A[$1] = $1 FS s
                s = ""
        }
        END {
                for ( k in A )
                        print A[k]
        }
' file

awk -F'\t' '