Sub essai()
Set d = CreateObject("Scripting.Dictionary")
For Each c In Range("a1", [a65000].End(xlUp))
If Not d.Exists(c.Value) Then
d(c.Value) = c & " " & c.Offset(0, 1)
Else
d(c.Value) = d(c.Value) & "," & c.Offset(0, 1)
End If
Next c
[e1].Resize(d.Count) = Application.Transpose(d.items)
End Sub