Advanced filter and transpose needs fix..
The advanced filter is not correctly filtering the data as unique. There is a column containing repeating numbers of rows have 12 monthly dates that repeat. When the advanced filter is invoked to filter column A as unique data, it pulling in 2/1/2012 twice
Secondly, when the “Transpose” key is pressed multiple times, it keeps filling adjacent rows and columns very strangely. The expectation is every time the transpose is pressed, it only fills in the range “mySourceRange”, no other cells
So the ideal goal is to filter unique values from column A to column B – which will then have only 12 months - no repeating data here. Please note: Column A can have upto 35 000 rows in actual,
Then sort that unique list and put in horizontally into range “mySourceRange”