Transpose the Punch Time

Dear Experts,

I am working on data of employee puncing details for analysis purpose. I need help and the data I am having is huge and currently doing everyting manually.

What I need to do is If one emplyee is punching three times in a day I need his punching details in the same row next column. Currently I am getting the data in one below aother. Example is shown below -

This is how I am able extract the report from system -
Camp Name Emp No Emp Name Punch Dt Punch Time
MISFAH 12440 SWAMY DOOSAMUNDI 7/1/2013 20:18:57
MISFAH 12440 SWAMY DOOSAMUNDI 7/1/2013 4:30:45
MISFAH 12440 SWAMY DOOSAMUNDI 7/1/2013 4:29:54
MISFAH 12440 SWAMY DOOSAMUNDI 7/1/2013 4:29:49

For the reporting purpose I need the data as mentioned below -

Camp EMP Code Name Date Punch Punch - 1 Punch - 2 Punch - 3 Punch - 4 Punch - 5 Punch - 6 Punch - 7
MISFAH 12440 SWAMY DOOSAMUNDI 7/1/2013 4:30:45 4:29:54 4:29:49 20:18:57

Can some one help me with a macro to reduce the manual effor.

Note : Employees do punch 10 time also in a day.

I have attached a working sheet
Sheet one Contains the Pivot table showing punching done by each employee in a day
Sheet two has the raw data extracted from system (Highlighet in green is used to show the output)
Sheet 3 has the Output (Example) that I am expecting.

I will be very graetful to the one helps. Thank you very much in advance.

Option Explicit

Sub macro_1()
Dim ws1, ws2, count1, count2
Set ws1 = Sheets("Raw Data")
Set ws2 = Sheets("Out Put")
count1 = 2
count2 = 1
Do Until ws1.Range("C" & count1) = ""
    If ws1.Range("C" & count1) = ws2.Range("C" & count2) Then
        ws2.Cells(count2, Columns.Count).End(xlToLeft).Offset(0, 1) = ws1.Range("E" & count1)
        count1 = count1 + 1
    Else
        count2 = count2 + 1
        ws2.Range("A" & count2 & ":E" & count2).Value = ws1.Range("A" & count1 & ":E" & count1).Value
        count1 = count1 + 1
    End If
Loop
End Sub

THANKS A TON. !!! I was spending half a day to do this activity, you have saved me a lot of time

Thanks Again