Organizing excel information into multiple lines

Here is a file explaining what I want to do: ex1.xlsx


I have an excel spreadsheet that is tracking attendence on different dates. The spreadsheet goes like this


1/1/12 2/2/12/ 3/3/12 etc
----------------------------------------------------------------------
Joe Smith Jane smith John smith
Joe doe Joe Smith Jane smith



there are many more names and many more dates. What I am trying to achieve is this: I want to be able to format the spreadsheet such that an individual name stays in the column that it is in, but it moves to a row that has all of the same name in it. Like so:

1/1/12 2/2/12/ 3/3/12 etc
----------------------------------------------------------------------
Joe Smith Joe Smith
Jane smith Jane smith
John smith
Joe Doe


Some spots will be empty since they may have not been there that day. Is there any way to do this in excel?


EDIT: The formatting is messed up. Hit "reply with quote" to see the correct formatting.