Set mondico = CreateObject("Scripting.Dictionary")
For i = 2 To [A65000].End(xlUp).Row
temp = Cells(i, "B") & "|" & Cells(i, "C") & "|" & Cells(i, "D") & "|" & Cells(i, "E") & "|" & Cells(i, "F") & "|" & Cells(i, "G") & "|" & Cells(i, "H") & "|" & Cells(i, "I") & "|" & Cells(i, "J") & "|" & Cells(i, "K") & "|" & Cells(i, "L") & "|" & Cells(i, "M") '(& "|" & Cells(i, "N")) suite retrait colonne compte géré
mondico(temp) = mondico(temp) & "-" & Cells(i, "A")
Next
[A2:N10000].ClearContents
[B2].Resize(mondico.Count) = Application.Transpose(mondico.keys)
[A2].Resize(mondico.Count) = Application.Transpose(mondico.items)
'Application.DisplayAlerts = False
[B2:B10000].TextToColumns Destination:=Range("b2"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar:="|"