title: Is there a way to filter or query unique results where unique is determined by one column but all columns are returned?
body: <p>My data source range is A:AK (A6:AK1478). </p>
  
  <p>The data is content (blogs, videos, etc) titles, authors, ratings, etc.(A:J) and values for how they map to categories (K:AK). 
  A:J is text data.
  K:AK is numerical data.</p>
  
  <p>There are duplicate entries I cannot remove. The title of each piece of content is in column F; this is the only column I look at to determine duplicate values.</p>
  
  <p>I want to query or filter (which is better?) all of this data into another sheet in order to obtain actual sums from columns K:AK. I want the formula to:</p>
  
  <ul>
  <li>Return all columns and rows from original data, AND</li>
  <li><em>Disregard duplicates only in column F</em></li>
  </ul>
  
  <p>I do not want to delete duplicates from the original source. 
  So far I have tried query and filter but no luck. I'm not an expert at advanced formulas, so any advice would be much appreciated!! </p>
  
  <p>I'm very sorry also that I cannot share this spreadsheet as it is work-related. I'm happy to answer any questions I can though.</p>
  
  <p>I have tried <code>=unique(query()</code> and <code>=unique(filter()</code> but this doesn't work because I can't figure out how to set column F as the range to look at for duplicates AND I want all columns returned, not just column F.</p>
  
  <p>update: Here is a screenshot of my current query output</p>
  
  <p><img src="https://i.stack.imgur.com/oIEpg.png" alt="screenshot"></p>