[COLOR="DarkSlateGray"][B]Sub toto()
Dim i, l, c
For i = 1 To 1 + Sheets(1).Range("A1").End(xlDown).Row \ 30
Sheets(1).Range(Cells(30 * i - 29, 1), Cells(30 * i, 2)).Copy Destination:=Sheets(2).Cells(l + 3, c + 1)
l = l - 34 * ((i Mod 4) = 0)
c = -(c + 3) * ((i Mod 4) <> 0)
Next i
End Sub[/B][/COLOR]