Private Sub CommandButton1_Click()
Dim Dico As Object, i&, Col&
Set Dico = CreateObject("Scripting.Dictionary")
Col = 3 'Changer le 3 par le numéro de la colonne ou sont les données
With Sheets("Feuil1")
For i = 2 To .Cells(Rows.Count, Col).End(xlUp).Row
Dico(.Cells(i, Col).Value) = .Cells(i, Col).Value
Next i
End With
Columns(1).ClearContents
Cells(2, 1).Resize(Dico.Count, 1) = Application.Transpose(Dico.Keys)
End Sub