Attendance sheet using excel

I am trying to make an attendance sheet using excel. Date and person absent will be entered in sheet2 in the following format

Date | Person Absent
June 1| xxx
June 1| yyy
June 2| zzz
June 3| www
June 4| xxx
June 4| yyy
June 4| zzz

and the sheet 1 will display it is tabular format
Date | xxx | yyy | zzz | www
June 1 | A | A | P | P
June 2 | P | P | A | P
June 3 | P | P | P | A
June 4 | A | A | A | P

I am using

Please Login or Register  to view this content.

but on June 1 'yyy' is showing 'P'. but if I remove the 1st row in sheet2 i.e, 'June 1 | xxx' the thing is working fine. Same happening for June 2.
How do I solve it?

Here is the file I have been working on. The details are there inside it. Thank you