Sub yy()
Dim Arr, i&, Brr
Sheet1.Activate
Arr = [a1].CurrentRegion
ReDim Brr(1 To (UBound(Arr) - 2) / 3, 1 To 6)
For i = 3 To UBound(Arr) Step 3
m = m + 1
For j = 0 To 2
Brr(m, j + 1) = Arr(i + j, 4)
Brr(m, j + 4) = Arr(i + j, 5)
Next
Next
[h4].Resize(UBound(Brr), 6) = Brr
End Sub