Formula to Exclude Duplicate Values

I have this spreadsheet with data pulled for different values. Sometimes the dates do not match because of lags in reporting. What I want to do is take all the dates from column A and transpose them in order to row 1 on sheet 2, but I do not want to include duplpicate values. Does anyone know of afunction or an array formula that would enable me to do this? Thanks!

This site shows how you can extract a unique list using an array formula:

http://www.get-digital-help.com/2009...om-one-column/

If you scroll down you will also see links about sorting unique lists.

Hope this helps.

Pete