Sub Macro5()
Dim DerLigne As Integer, I As Integer
DerLigne = Range("A" & Rows.Count).End(xlUp).Row
With Sheets("Feuil2")
.Rows("1:" & DerLigne - 1).Insert Shift:=xlDown
Rows("2:" & DerLigne).Copy .Range("A1")
For I = 1 To DerLigne
If .Range("A" & I) = "" Then .Rows(I).Delete
Next I
End With
End Sub