bonsoir,
une macro à tester.
Sub concentre()
With Worksheets("Feuil1")
dl = .Range("A" & Rows.Count).End(xlUp).Row
l = dl + 2
For i = 2 To dl
If .Cells(i, 1) <> .Cells(i - 1, 1) Then
l = l + 1
.Rows(i).Copy .Rows(l)
Else
For j = 1 To 41
If .Cells(i, j) <> .Cells(i - 1, j) And .Cells(i, j) <> "" Then
.Cells(l, j) = .Cells(l, j) & vbNewLine & .Cells(i, j)
End If
Next j
End If
Next i
End With
End Sub