Sub ListeInverses()
Set d = CreateObject("Scripting.Dictionary")
For Each c In [A2].Resize(Application.CountA([a:a]))
d(c.Value) = d(c.Value) & c.Offset(, 1) & " "
Next c
ligne = 2
For Each c In d.keys
Cells(ligne, "D") = c
a = Split(d.Item(c), " ")
Cells(ligne, "D").Offset(, 1).Resize(, UBound(a) + 1) = _
Application.Transpose(Application.Transpose(a))
ligne = ligne + 1
Next c
End Sub