I am having problems with a recorded macro:

Raw Data on Sheet 1:

C
3 424a356
4 424a356
5 424a356
6 424b650
7 424b650
8 401b000
9 401b000
10 407b000

Copy and Sorted by Unique Value on Sheet 2:

A
2 424a356
3 424a356
4 424b650
5 401b100
6 407b000

Even though I request unique values, it continues to copy the top two values
which are the same. It has something to do with a header, maybe? Is there
some code that could get me around this problem? Your help is greatly
appreciated. Thanks.