I have a sql table with :

Acitvity Date Value
ABC 7/11 10
DEF 7/11 98
ABC 7/12 23
DEF 7/12 100
SER 7/12 67
GRH 7/13 123
HJY 7/14 12


I want it to be reported in the following format:

Activity 7/11 7/12 7/13 7/14
ABC 10 23
DEF 98 100
SER 67
GRH 123
HJY 12

How do I do that? Please help. Thanks.

nawk -f muk.awk mySQLfile

muk.awk:
[cove]
FNR > 1 { arr[$1] = ($1 in srr) ? arr[$1] OFS $3 : $3; act[$2] }
END {
printf("Activity")
for (i in act)
printf("%s%s", OFS, i)
printf("\n")

for (i in arr)
print i, arr[i]
}
[/code]

Thanks for the prompt response.

It did not recognize nawk ...

and 'awk' or 'gawk'?

It recognizes awk and gawk.