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