Summarise a column

Hi,

I have a spread sheet that has roughly 75 rows in column G,

Each cell has text in that sometimes repeats, so G1 might have the same text as G15 and G18.
How can I extract the column information to a different location without the repeats. In other words I'd like to do down column G and get a list of all the cell contents ignoring the repeated text and place it in say column P

Hi,

Select the column G. --> Click advance filter in data tab -->select the "copy to another location" button.

List range : g1:g75

copy to : p1

Click the Check box which says "unique record only"

Now you should have unique records of column G in column P