Sub TransferData()
Dim sArr(), Res(1 To 10000, 1 To 6)
Dim I As Long, J As Long, K As Long, lR As Long
I = 1
Do While Sheet2.Cells(1, I) <> ""
lR = Sheet2.Cells(1, I).End(xlDown).Row
sArr() = Sheet2.Cells(1, I).Resize(lR, 5).Value
For J = 3 To UBound(sArr, 1)
K = K + 1: Res(K, 1) = sArr(J, 1)
Res(K, 2) = sArr(J, 1): Res(K, 3) = sArr(J, 2)
Res(K, 4) = sArr(J, 3): Res(K, 5) = sArr(J, 4)
Res(K, 6) = sArr(J, 5)
Next J
I = I + 6
Loop
If K Then
Sheet3.Range("I2").Resize(K, 6) = Res
MsgBox "Done", vbInformation, "GPE"
End If
End Sub