Affaire résolut grace a moi meme merci de votre aide!!!
Code macro :
Sub test()
With Sheets(1)
Dim DernLigne As Long
DernLigne = Sheets(1).Range("A" & Rows.Count).End(xlUp).Row
For i = 3 To DernLigne
If Cells(i, 1).Value = Cells(i - 1, 1).Value Then
For j = 6 To 22 'de la col F:F à V:V
Cells(i - 1, j).Value = Cells(i - 1, j).Value & " ; " & Cells(i, j).Value
Next j
Rows(i).Delete
i = i - 1
End If
Next i
End With
End Sub