Sub Transfert()
Application.ScreenUpdating = False
DerLig = Sheets("Feuil1").Range("A65500").End(xlUp).Row
' Transfert cellule en A dans cellule en B
For i = 2 To DerLig
If Cells(i + 1, "B") = "" Then
Cells(i, "B") = Cells(i + 1, "A")
End If
Next i
' Suppression des lignes
For i = DerLig To 2 Step -1
If Cells(i, "B") = "" Then
Rows(i).Delete
End If
Next i
End Sub