Shell Programming and Scripting

awk ' { a[$2]=$2; c[$2]++ } END {
  printf "file name\t";
  for (i=0; i<=11; i++) { if(i==11) printf "\n"; else printf "A" i "\t"; }
  printf FILENAME"\t";
  for (i=0; i<=11; i++) { if(i==11) printf "\n"; else printf (c["A" i]?c["A" i]:0) "\t"; }
}' SR345_pl.txt

$ awk   '{ar[$2]++}
         END {  printf " file name\t";
                for (i=1; i<=10; i++) printf "A"i"\t"; printf "\n"
                printf "%10s\t", FILENAME;
                for (i=1; i<=10; i++) printf "%2d\t", ar["A"i]+0; printf "\n"
             }
        ' file
 file name    A1    A2    A3    A4    A5    A6    A7    A8    A9    A10    
      file     0     4     2     0     2     0     1     0     1     0