Shell Programming and Scripting

ABC   high
ABC   high
ABC   medium
ABC   low
ABC   low
XYZ   low
XYZ   low
XYZ   low
XYZ   high
XYZ   high

ABC  2  1  2
XYZ  2 0  3

$ awk '{ S[$1]=1 ; V[$1 $2]++ }
 END {
         for(K in S)
                 printf("%s\t%d\t%d\t%d\n", K, V[K "low"], V[K "medium"], V[K "high"]);
         }' < data

ABC     2       1       2
XYZ     3       0       2
$

$ cat anycat.awk
{       S[$1]=1;        C[$2]=1;        V[$1 $2]++;     }
END {
        printf("#");
        for(COL in C)   printf("\t%s", COL);
        printf("\n");

        for(K in S)
        {
                printf("%s", K);
                for(COL in C)
                {
                        printf("\t%d", V[K COL]);
                }

                printf("\n");
        }
}
$ awk -f anycat.awk < data
#       high    low     medium
ABC     2       2       1
XYZ     2       3       0
$