Simple Looping Query

Hi,

In A1:A1000 I have a list of product names; Product A, Product B etc, each appearing more than once. I would like to create a simple macro that extracts from column A, and puts into a new range starting at C1, each of the names of the products. So C1 would contain the text "Product A", C2 would contain the text "Product B" etc until column C contains the list of product names from A1:A1000.

I have little doubt that this requires just a few lines of VBA code but even that's beyond me, so can someone please suggest a solution?

Thanks!