Shell Programming and Scripting

Hello everyone,
I would like to use awk to parse a file with three columns in, like:
monday 0 1
monday 1 1
monday 2 1
monday 3 1
monday 4 1
monday 5 1
tuesday 0 5
tuesday 1 1
tuesday 2 1
tuesday 3 1
tuesday 4 1
wednesday 0 1
monday 5 25

they represent the day the hour and the number of transactions.
There are thousand of lines, I would like to generate a single table
with hours as headers, the row name will be the day name, and the cells will be the average number of transaction for that day name in that particular hour like:
=========== 0 1 2 3 4 5 6 7 ... 23
Monday xxx xxx xxx ... . . . . . . . . . . . . . .
Tuesday xxx xxx xxx ... . . . . . . . . . . . . . .
Wednesday xxx xxx xxx ... . . . . . . . . . . . . . .
.
.
.
Sunday xxx xxx xxx ... . . . . . . . . . . . . . .

I only have access to the standard AWK, no gawk ....
I hope you understand and can help.
Thanks.

Thanks for sharing.
Where exactly are you stuck and how can we help you you?

I modified this code, but i do not have access to the asorti function....what can I proceed would it work if I do not sort and just use 'count of' array for my loop control?

awk '{y[$2];i[$1];c[$1,$2]+=$2;d[$1,$2]++}END{ny=asorti(y);ni=asorti(i);printf "ID";for(j=1;j<=ny;j++); printf ";%s", y[j];print"";for(x=1;x<=ni;x++){
printf i[x];
for(j=1;j<=ny;j++);printf ";%s", c[i[x],y[j]]/d[i[x],y[j]] ""
print""
}}' file

Thanks.