title: Powershell to add columns, remove lines and fill text in a CSV file
body: <p>Total Powershell noob here. Please help!</p>
  
  <p>I have a CSV file that looks like this:</p>
  
  <pre><code>Office,First Name,Last Name,email
  Pancacke Group,Lidia,Gheno,lidiapancackes@yahoo.com
  Miller Tracy Carmel Valley,Paulina,Mastros,paulina@gmail.com
  </code></pre>
  
  <p>I need to have a powershell way to make it look like this:</p>
  
  <pre><code>,,,Pancacke Group,Test,Lidia,Gheno,lidiapancackes@yahoo.com
  ,,,Miller Tracy Carmel Valley,Test,Paulina,Mastros,paulina@gmail.com
  </code></pre>
  
  <p>Summarizing needs:</p>
  
  <ol>
  <li>Add three columns before the first column, Office</li>
  <li>Add another column between Office and First Name</li>
  <li>Fill the column between Office and First Name with the word <code>Test</code></li>
  <li>Remove first line with the Header</li>
  </ol>
  
  <p>Thanks in advance for your help!</p>