Changing certain columns from vertical to horizontal?

I just started a new project where I work. I have pretty basic excel skills but have been given a very daunting excel task. Please see the attached files. All the columns E-I that are of the same date need to be listed horizontally in the row across that date. I was wondering if there is a quicker way to do this other than copy pasting each line as the document has 65536 rows and this is only last names A-J. Thanks for any help.

If you do a dummy column in column J that has a counting formula as such that will tell you what instance it is of the same person/date. Then you just need to find the highest date/person instance (i.e. John Doe 6/12/07 has 14 entries)

Count Formula in column J as follows (assuming headers in row 1):
=SUMPRODUCT(--($A$2:$A2=$A2),--($B$2:$B2=$B2),--($D$2:$D2=$D2))
Once this is done calculating I highly recommend copying and pasting as values so it doesn't try to recalculate all of this agian.

Then whatever information you need to have copied in you would setup headers for those (assume that the column header for E is TimeCode and F is TimeDesc)

Enter your headers on column K-?? for the max number of itterations (i.e. 14 from the example above). If possible add a single row on top of the spreadsheet above the headers (if not possible move a single row to another worksheet for now)
In the new row 1, above the first iteration headers put 1, above the second 2, etc.

Now in Cell K3 you can enter this formula
=INDEX($E$1:$I$65536,SUMPRODUCT(--($A$1:$A$65536=$A3),--($B$1:$B$65536=$B3),--($D$1:$D$65536=$D3),--($J$1:$J$65536=A$1),ROW($A$1:$A$65536)),MATCH(K$2,$E$2:$I$2,0))

Copy and paste that all the way down from all your itterations of headers.
Go eat lunch, build a model airplane, travel around the world, go on vacation. Possibly when you do all of that when you get back the formulas will have calculated, you can copy-paste as values and then just sort column J and delete everything but 1's.

Seriously though, my solution will work, but sumproduct gets very boggy with tons of data like that. I'd suggest macros, but my skill at doing them isn't very good.

Thanks for the help so far, here is a sample of the spreadsheet.

Sorry, that was just a couple of the original. I (and my boss) really appreciate the help so far. I am now wondering what the best the way to remove the lines once they have been moved is?