Bonjour,
un essai ici
P.
ou encore en VBA:
Sub regrouper_affectation()
'
' 11/2015
'
Set f = Sheets("feuil1")
Set f1 = Sheets("feuil2")
Set d = CreateObject("Scripting.Dictionary")
Set d2 = CreateObject("Scripting.Dictionary")
f.Select
For Each c In f.[e5].Resize(Application.CountA(f.[e:e]))
If c.Value <> "" Then
If Not d.exists(c.Value) Then
d(c.Value) = c.Offset(, -4)
Else
d(c.Value) = d(c.Value) & "|" & c.Offset(, -4)
End If
End If
Next c
ligne = 4: col = 18
f1.Select
For Each c In d.keys 'pour chaque personne
f1.Cells(ligne, col) = c
a = Split(d.Item(c), "|")
f1.Cells(ligne + 1, col).Resize(UBound(a) + 1) = Application.Transpose(a)
col = col + 1
Next c
f1.Select
End Sub