Sub test()
Dim arr, brr, i%, j%, n%
arr = [a3].CurrentRegion
ReDim brr(1 To Application.CountA(arr) - 3, 1 To 1)
For i = 2 To UBound(arr)
For j = 1 To 3
If arr(i, j) <> "" Then
n = n + 1
brr(n, 1) = arr(i, j)
End If
Next j
Next
[f4:f1000].Clear
[f4].Resize(UBound(brr)) = brr