Sub t()
Dim arr, brr
Dim i As Integer, j As Integer
arr = Range("C4:ad" & Cells(Rows.Count, 4).End(xlUp).Row)
ReDim brr(1 To UBound(arr) - 1, 1 To 1)
For i = 2 To UBound(arr)
For j = 1 To UBound(arr, 2)
If arr(i, j) = 0 Then brr(i - 1, 1) = arr(i - 1, j)
Next j
Next i
Range("ae5").Resize(UBound(brr), 1) = brr
End Sub