Sub test()
Dim I&, X&, T As Variant
Application.ScreenUpdating = False
With Sheets("Feuil1")
For I = 9 To .Cells(.Rows.Count, 1).End(3).Row
T = .Range(.Cells(I, 1), .Cells(I, 20))
X = .Cells(.Rows.Count, 21).End(3)(2).Row
X = IIf(X < 9, 9, X)
.Cells(X, 21).Resize(UBound(T, 2), 1) = Application.Transpose(T)
Next I
End With
Application.ScreenUpdating = True
End Sub