Excel 2007 : Calling multiple records to another sheet thru identical lookups

I have the following data in an Excel Sheet. Starts A1;
e.g. in Cell A1 is the Date 04/08/2011 and B1 is the Time 13:39:47 and C1 is the Trigger (e.g. IN, OUT etc.)

04/08/2011 13:39:47 IN
04/08/2011 13:45:47 MISC-OUT
04/08/2011 13:59:47 MISC-IN
04/08/2011 17:30:23 OUT
05/08/2011 8:36:23 IN
05/08/2011 9:46:46 BANK-OUT
05/08/2011 12:08:19 BANK-IN
05/08/2011 12:20:19 BANK-OUT
05/08/2011 12:50:19 BANK-IN
05/08/2011 12:59:56 OUT
06/08/2011 8:49:00 IN
06/08/2011 9:54:54 BANK-OUT
06/08/2011 13:11:51 BANK-IN
06/08/2011 17:15:44 OUT

I have this data in vertical order as a result you will notice repetition of date again and again against each record.

In another sheet starting from A1 i have the Dates already mentioned starting from 1st of the month till the last (total 31 days - every date is mentioned just once).

I want Time Records to come up Horizontally against the date in Sheet 2 along with it's relevant trigger irrespective of the number of records of each date of Sheet 1.(the number of transaction in one day can be as many as 50~60 and always the trigger could be different).

I want Result to appear like this..

04/08/2011 13:39:47 IN 13:45:47 MISC-OUT 13:59:47 MISC-IN 17:30:23 OUT
05/08/2011 8:36:23 IN 9:46:46 BANK-OUT 12:08:19 BANK-IN 12:20:19 BANK-OUT 12:50:19 BANK-IN 12:30:56 OUT
06/08/2011 8:49:00 IN 9:54:54 BANK-OUT 13:11:51 BANK-IN 17:15:44 OUT

I hope i am able to convery my question well.

Look this:

Assuming there can't be two same times (in second) on the same date.

Actually, previous won't work if you have any same time at all.
This would work only for unique time for each day...

In other words can't have:

Please Login or Register  to view this content.

Great! Thank you so much. Of course, there won't be same same time (in seconds) at all. Thanks again.

I hope this would work perfect if the same time repeats on a different date. Pls confirm.

So nice of you! Thanks.

Originally Posted by zbor

Look this:

Dear,
Thank you again for your help!
Please have a look at the attached file; is there any way out that those record that are appearing in Column I gets Underlined or Bold or Italic if they are exceeding 9:10:59.

Regards,

Upload example

(note if it+s greater then 1MB it will be discarded)