title: How to group and select unique values in PowerShell?
body: <p>I've asked this question on the SharePoint StackExchange w/ no luck</p>
  
  <p>I have a CSV file with one column, SharePoint Site URLs, many of which are duplicates</p>
  
  <pre><code>Column Title
  Site C URL
  Site A URL
  Site B URL
  Site C URL
  Site C URL
  Site A URL
  </code></pre>
  
  <p>How can I retrieve the rows so the I only have unique sites:</p>
  
  <pre><code>Site A URL 
  Site B URL 
  Site C URL 
  </code></pre>
  
  <p>I've tried:</p>
  
  <pre><code>$CSVLocation = 'C:\data\data.csv'
  $siteURLs = Import-CSV -Path $CSVLocation 
  $siteURLs | Group-Object -Property 'Column Title' | Select-Object -Unique
  </code></pre>