Sub Transpose_bis()
Dim i&, j&, f As Worksheet: Set f = Sheets("Feuil2")
With Application
.ScreenUpdating = False
For i = 1 To Cells(Rows.Count, 1).End(3).Row - 3 Step 4
j = j + 1: f.Cells(j, 1).Resize(, 4) = .Transpose(Range("A" & i).Resize(4))
Next i
End With
f.Columns("A:D").AutoFit
End Sub