Listing names in one column

[jlokesh16]

I have an column B, in which there are names of various people (Only the first Name). I want to have the names displayed only once in Col A.
EG: In column B i have names like John, George, Jim, John, Pam, Jim. So the Column A should display names John, George, Jim, Pam.

 

[Aladin Akyurek]

Book1
	A	B
1	4
2	John	John
3	George	George
4	Jim	Jim
5	Pam	John
6		Pam
7		Jim
Sheet1

In A1 control+shift+enter, not just enter:

=SUM(IF(FREQUENCY(IF($B$2:$B$7<>"",MATCH($B$2:$B$7,$B$2:$B$7,0)),ROW($B$2:$B$7)-ROW($B$2)+1),1))

In A2 control=shift+enter, not just enter, and copy down:

=IF(ROWS($A$2:A2)>$A$1,"",INDEX($B$2:$B$7,SMALL(IF(FREQUENCY(IF($B$2:$B$7<>"",MATCH($B$2:$B$7,$B$2:$B$7,0)),ROW($B$2:$B$7)-ROW($B$2)+1),ROW($B$2:$B$7)-ROW($B$2)+1),ROWS($A$2:A2))))