UNIX for Dummies Questions & Answers

ESR1	ANASTROZOLE	NA	FDA_approved
ESR1	CISPLATIN	NA	FDA_approved
ESR1	DANAZOL	agonist	NA
ESR1	EXEMESTANE	NA	FDA_approved
FOXA1	Cisplatin	NA	NA
GATA3	NA	NA	NA

ESR1	ANASTROZOLE(NA/FDA_approved);CISPLATIN(NA/FDA_approved);DANAZOL(agonist/NA);EXEMESTANE(NA/FDA_approved)
FOXA1	Cisplatin(NA/NA)
GATA3	NA(NA/NA)

awk '
        {
                A[$1] = A[$1] ? A[$1] ";" $2 "(" $3 "/" $4 ")" : $1 "\t" $2 "(" $3 "/" $4 ")"
        }
        END {
                for ( k in A )
                        print A[k]
        }
' file

awk     '!B[$1]         {A[++i]=$1}
                        {B[$1]=B[$1]";"$2"("$3"/"$4")"}
         END            {for(j=1;j<=i;j++) print A[j] "\t" substr(B[A[j]],2)
                        }
        ' file