Sub demo()
[a1:g1000].ClearContents
With Sheets(1)
For i = 1 To .[a1].End(4).Row Step 7
For j = 1 To .[a1].End(2).Column
r = r + 1
Sheets(2).Cells(r, 1).Resize(1, 7) = Application.Transpose(.Cells(i, j).Resize(7, 1))
Next
Next
End With
End Sub
Sub demo()
[a1:g1000].ClearContents
With Sheets(1)
For i = 1 To .[a1].End(4).Row Step 7
For j = 1 To .[a1].End(2).Column
r = r + 1
Sheets(2).Cells(r, 1).Resize(1, 7) = Application.Transpose(.Cells(i, j).Resize(7, 1))
Next
Next
End With
End Sub