Sub TEST_1()
Dim i&
With Sheet5
For i = 4 To .Range("B" & Rows.Count).End(xlUp).Row Step 3
If Not IsEmpty(.Cells(i, 5)) Then .Cells(i, 3) = .Range("E2") Else .Cells(i, 3) = ""
If Not IsEmpty(.Cells(i, "I")) Then .Cells(i, 3) = Range("I2")
If Not IsEmpty(.Cells(i, "M")) Then .Cells(i, 3) = Range("M2")
If Not IsEmpty(.Cells(i, "Q")) Then .Cells(i, 3) = Range("Q2")
If Not IsEmpty(.Cells(i, "V")) Then .Cells(i, 3) = Range("V2")
If Not IsEmpty(.Cells(i, "Y")) Then .Cells(i, 3) = Range("Y2")
If Not IsEmpty(.Cells(i, "AC")) Then .Cells(i, 3) = Range("AC2")
If Not IsEmpty(.Cells(i, "AG")) Then .Cells(i, 3) = Range("AG2")
Next i
End With
End Sub