Private Sub CommandButton1_Click()
Dim Cl As Range, k
k = 1
With Sheet1
.Columns("H:L").Clear
Set Cl = .[A1]
Do While Cl.Offset <> ""
.Cells(k, "H") = Cl.Value
.Cells(k, "I") = 0
.Cells(k + 1, "I") = 1
.Cells(k, "I").Resize(2).AutoFill Destination:= _
.Cells(k, "I").Resize(24), Type:=xlFillDefault
.Cells(k + 1, "J").Resize(, 3).Value = Cl.Offset(, 2).Resize(, 3).Value
.Cells(k + 7, "J").Resize(, 3).Value = Cl.Offset(1, 2).Resize(, 3).Value
.Cells(k + 13, "J").Resize(, 3).Value = Cl.Offset(2, 2).Resize(, 3).Value
.Cells(k + 19, "J").Resize(, 3).Value = Cl.Offset(3, 2).Resize(, 3).Value
k = k + 24
Set Cl = Cl.Offset(4)
Loop
End With
End Sub