title: sqlcmd - output to csv | each value in single column
body: <p>What I do:</p>
  
  <pre><code>$data = Invoke-Sqlcmd -Query "USE DB-Name SELECT DISTINCT name1, name2, name3, name4, name5 FROM Table WHERE Name1 in ('Servername')" -ServerInstance "Name"
    | Format-Table
  </code></pre>
  
  <p>When I <code>Out-File</code> this, I've got this in one string/field:</p>
  
  <pre><code>"value1","value2","value3","value4","value5"
  </code></pre>
  
  <p>What I need: every value in a separate column in a <code>.csv</code> file.</p>
  
  <p>What I've tried:</p>
  
  <pre><code>$data | Out-File -Path C:\users\Username\Desktop\List.csv -h-1 -W
  </code></pre>
  
  <p>Thank you so much for your help!</p>