Shell Programming and Scripting

100 D 22
100 T 33
100 C 89
101 C 55
101 D 44
102 D 88
103 T 22
103 C 13

<number>  <D value> <C Value>  <T Value>

100  22 33  89
101  44 55   0
102  88  0    0
103    0 13  22

awk '{A[$1];D[$1$2]=$3} END {for (i in A) print i,D[i"D"]+0,D[i"C"]+0,D[i"T"]+0}' file
100 22 89 33
101 44 55 0
102 88 0 0
103 0 13 22

awk '
	{
	X[$1];Y[$1$2]=$3;Z[$2]
	} 
END {
	printf "\t"
	for (j in Z) printf "%s\t",j
	print ""
	for (i in X) {
		printf "%s\t",i
		for (j in Z) 
			printf "%s\t",Y[i j]+0
		print "" 
		}
	}' file

        C       D       T
100     89      22      33
101     55      44      0
102     0       88      0
103     13      0       22