Search Results

An awk approach, if order doesn't matter:
awk '
{
A[$1] = A[$1] ? A[$1] ";" $2 "(" $3 "/" $4 ")" : $1 "\t" $2 "(" $3 "/" $4 ")"
}
END {
...

Should order matter, based on Yoda's proposal, tryawk '!B[$1] {A[++i]=$1}
{B[$1]=B[$1]";"$2"("$3"/"$4")"}
END {for(j=1;j<=i;j++) print A[j]...

Welcome to Forums
$ cat file1
ESR1 1 15 ggtga
ESR1 7 18 tgcagt
FOXA1 3 10 gtgat
FOXA1 10 20 tgacc

$ cat file2
abcsd 34 ESR1 1 15
dfdf 55 ESR1 10 17
sdf 44 FOXA1 3 10
fdf 53 FOXA1 30 40
...