Sub Macro3()
Dim ligne As Long, Compteur As Long, Fin As Long
ligne = Cells(Rows.Count, 1).End(xlUp).Row
For ligne = 2 To ligne
Cells(ligne, 1).Resize(, 5).Copy
Compteur = Cells(Rows.Count, "F").End(xlUp).Row + 1
Cells(Rows.Count, "F").End(xlUp).Offset(1).PasteSpecial Paste:=xlValues, SkipBlanks:=True, Transpose:=True
Cells(Compteur, "G") = Cells(ligne, 6)
Compteur = Compteur + 1
Next
Fin = Cells(Rows.Count, "F").End(xlUp).Row
With Range(Cells(ligne + 1, "G"), Cells(Fin, "G"))
.SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=R[-1]C"
.Value = .Value
End With
Range(Cells(ligne, "G"), Cells(Rows.Count, "F").End(xlUp)).Cut Cells(ligne + 1, 1)
End Sub