Copy and paste excluding zeros

In Excel 2007, you can use the Data tab, and there you will find a function "Remove Duplicates".

It can be used by adding a new column which counts from 1 downwards (on the left of your dataset, and another adjacent which has logic which represents that value unless the box to the right (the empty datacell in your real data) is empty otherwise make it an X(or something non numerical).

Filter the entire dataset for duplicates, but only tick the new column with x'es for parsing.

Bit long winded but no script required! There are some powerful time savers in that tab - worth playing with if you are blessed with office 2k7.