Sub EnColonne()
Const FeuilSource = "helper", CellSource = "B3"
Const Feuilcible = "helper", CellCible = "C6"
Dim T
T = Split(OterDoublons(Sheets(FeuilSource).Range(CellSource)), ",")
With Sheets(Feuilcible)
.Range(.Range(CellCible), .Cells(.Rows.Count, .Range(CellCible).Column)).ClearContents
If UBound(T) >= 0 Then .Range(CellCible).Resize(UBound(T) + 1) = Application.Transpose(T)
End With
End Sub