Repeated number and multiple results

Hello,

Want to know i have two columns in excel, sheet 1
Column 1 - date
Column 2 - Unique number

Now, dates are not given in a customised format (3rd September may come before 23rd August).

Second sheet contains date in a customized format with around 10 rows for single date (1-sep-2010 is repeated in 10 rows in a line).

I want that the unique number for each date should come in a customised format in sheet two, that is if 1-sep-2010 is there 5 times in sheet 1 then the unique number should come in a proper line in front of the given date.

Have tried with VLOOKUP but it given the unique number present in the 1st row only, it does'nt capture the other numbers given below opposite to same date.

Thanks in advance for help...