I am trying to simulate a Pivot Table using the new array functions in Excel 365. I have loaded my data from a secondary workbook into the data model (WtData). In it is a date field (Date). I want to list the years in the Date field across columns. I am guessing that I need something like "TRANSPOSE(UNIQUE(YEAR(?)))". But I cannot find a solution for how to specify all the dates in the table. Can it be done? If so, how? Thanks.