Shell Programming and Scripting

Name | organization
John | INT
Abby| DOM
John | DOM
John | MIX
Jason | INT
Anna | DOM
Abby |MIX

Name | organization
John | INT, DOM, MIX
Abby | DOM, MIX
Jason | INT
Anna | DOM

$ awk -F"|" 'NR==1{ print; next};
        { A[$1]=A[$1] ", " $2 }
        END { for(X in A) {
                         print X "|" substr(A[X], 2);
                 } }' datafile

Name | organization
Jason |  INT
Abby|  DOM
Abby | MIX
John |  INT,  DOM,  MIX
Anna |  DOM

$

awk -F\| '{
   if (NR>1) {
        if (x[$1]) x[$1] = x[$1] "," $2
        else {y[NR] = $1; x[$1] = "|"$2}
   } else print
} END {
  for (i=2;i<=NR;i++)
      if (y[i] in x) print y[i] x[y[i]]
}' file

awk -F\| '{
   if (NR>1) {
      if (!z[$1,$2]++)
         x[$1] = x[$1] ? x[$1] "," $2 : "|" $2
   } else print
} END {for (i in x) print i x[i]}' file

# awk -F'[|]' '{
if(NR==1)print;else{gsub(" ","",$1);a[$1]=a[$1]","$2}}END{for(i in a){
sub(",","|",a[i]);gsub(", *",", ",a[i])if(length(a[i])<15)print i,a[i]}
}' infile
Name | organization
Anna | DOM
Abby | DOM, MIX
Jason | INT