I have data in this format and want to arrange in the given format:
Data Have:
AC-No. Date Absent
114 21/03/2012
114 22/03/2012
114 23/03/2012
114 24/03/2012 True
114 26/03/2012 True
114 27/03/2012
114 28/03/2012
114 29/03/2012
273 21/03/2012
273 22/03/2012
273 23/03/2012
273 24/03/2012 True
273 26/03/2012
273 27/03/2012 True
273 28/03/2012
273 29/03/2012
1030 21/03/2012
1030 22/03/2012
1030 23/03/2012
1030 24/03/2012 True
1030 26/03/2012

Now, I want to arrange the data in this format

Emp_cd 21 22 23 24 25 26 27 28
114 0 0 0 A 0 A 0 0
273 0 0 0 A 0 0 A 0
1030 0 0 0 A 0 0 0 0
1084 0 0 0 0 0 0 0 0

Thanks for help,
Regards,
Shiven