title: Format Google Sheet to show only go first instance of each value in column
body: <p>Can Google sheets format a column using QUERY where it only shows the first instance of each unique value in a column.</p>
  
  <p>For example, I have a column of dates ordered descending. I'd like to have a column for year, where at the beginning of each year in the date column, the year is shown on the year column, but just for the first record. 
  Like a pivot table, but no expanding and collapsing</p>
  
  <p>I can get a year column to show the year on each row, but not just the first (max) date row for each year</p>