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!