Shell Programming and Scripting

awk '{if(!X[$1]++){FIR=FIR?FIR"_"$2:$2} {Y[$1]=$1;Z[$2]++}}END{n=split(FIR,FCL,"_");for(i=1;i<=n;i++){s=s?s"\t"FCL[i]:"\t"FCL[i]} print s; for(j in Z){s=j;for(i=1;i<=n;i++){split(FCL[i],PK," ");p=Y[PK[1],PK[2],j]?Y[PK[1],PK[2],j]:0;s=s"\t\t"p};print s}}'

1 15.3
1 15.5
2 15.8
2 15.9
3 16.0
3 16.1
4 16.8
4 17.0
5 17.5
6 18.0
1 18.0
10 17.1

       15.0 - 15.9   16.0 - 16.9   17.0 - 17.9   18.0 - 18.9 
1           2             0             0             1
2           2             0             0             0
3           0             2             0             0
4           0             2             0             0
5           0             0             1             0
6           0             2             0             1
10          0             0             1             0

awk '
        {A[$1]
         B[int($2)]
         C[$1,int($2)]++
        }
END     {for (b in B) printf "\t%d.0 - %d.9", b, b
         printf ORS
         for (a in A)   {printf "%s", a
                         for (b in B) printf "\t%d", C[a,b]
                         printf ORS
                        }
        }
'  file
	15.0 - 15.9	16.0 - 16.9	17.0 - 17.9	18.0 - 18.9
10	0	0	1	0
1	2	0	0	1
2	2	0	0	0
3	0	2	0	0
4	0	1	1	0
5	0	0	1	0
6	0	0	0	1