Sub Deplacer()
Dim t, max&, n&, i&, j&, k&
With Sheets("Feuil1")
t = Intersect(.Range("A1").CurrentRegion, .Rows("2:17"))
End With
If UBound(t, 2) > 9 Then
max = 16 * (1 + Int((UBound(t, 2) - 9) / 3))
ReDim v(1 To max, 1 To 12)
For j = 10 To UBound(t, 2) Step 3
For i = 1 To 16
n = n + 1
For k = 1 To 9: v(n, k) = t(i, k): Next
For k = 1 To 3: v(n, k + 9) = t(i, j + k - 1): Next
Next i
Next j
End If
With Sheets("Feuil2")
.Range("A1").CurrentRegion.Clear
Sheets("Feuil1").Range("a1:L1").Copy .Range("a1:L1")
If UBound(t, 2) > 9 Then .Range("a2").Resize(n, UBound(v, 2)) = v
.Columns("L:L").NumberFormat = "# ##0.000"
.Activate
End With
End Sub