请问如何将第一列相同的第二列合到一行

chmod755

$ cat xx00
XP_002960178    GO:0055114
XP_002960178    GO:0003824
XP_002960417    GO:0034968
XP_002960417    GO:0018024

$ awk '{a[$1]=a[$1]==""?$2:a[$1]FS$2}END{for(i in a)print i,a}' xx00
XP_002960417 GO:0034968 GO:0018024
XP_002960178 GO:0055114 GO:0003824

fh21_xuejinlian

awk '{a[$1]=a[$1]" "$2}END{for(i in a)print i,a[i]}' file

moperyblue

1. sed -r ':a;N;s/((\b\S+\b).*)\n\2/\1/;ta;P;D'
   
2. awk '{a[$1]=a[$1] FS $2}END{for(i in a)print i,a[i]}'
   
3. awk '{a[$1]=a[$1] FS $2}!b[$1]++{c[++d]=$1}END{for(;i++<d;)print c[i],a[c[i]]} #按第一列顺序

复制代码