Sub test()
For i = 1 To Range("A" & Rows.Count).End(xlUp).Row
Range("E" & (i - 1) * 3 + 1) = Range("A" & i)
Range("E" & (i - 1) * 3 + 2) = Range("A" & i)
Range("E" & (i - 1) * 3 + 3) = Range("A" & i)
Range("H" & (i - 1) * 3 + 2) = 0
Range("H" & (i - 1) * 3 + 3) = Range("C" & i)
Range("H" & (i - 1) * 3 + 4) = Range("C" & i)
Next i
End Sub