Awk output format help!!! Urgent!!!!

Hello!!

I am capturing and counting certain uniq occurance of certain evet from large log files.

below is my output I m getting with my script:

No of Messages Date Hour
150 Aug15 1
234 Aug15 2
345 Aug15 3
. . .
. . .
xxx Aug15 23
. . .
xxxx Aug22 23

As you see I m getting total of 23 entry for 7 days. that means total of 161 entries all horizontal.

The desired format I want is this:

Hr Aug15 Aug 16 .........Aug 22 <---Day
1 100 200 .......... 300 <--No of messages
2 234 1000 23

In short I want output in kind of tabular format.

Any help would be appreciated!!!its so urgent for me!!!!

Thanks in advance for help

are you trying to filter the details on weekly basis or on daily basis

weekly basis

you can change the fileters for each day and concatenate to a variable for the week days

var=<o/p for aug15 and HR 1>||<o/p for aug 16 and HR 1>|| <o/p for aug 17 and HR 1>...

assuming "||" is concatenation operator..

split -l 23 logfile; paste -d' ' xa* | awk '{printf("\n%s ",$3); for(i=1;i<NF;i=i+3) printf("%s ",$i);}' > outfile.

Probably u can work on the header line...