title: Insert data if previous column contains data
body: <p>I'm trying to think of a way where I can have a Powershell script check an Excel or CSV file, read the last column and then insert a static data for each row that has data. 
  For example this is the original file:</p>
  
  <pre><code>| Id  | Price   | Description                     |
  |-----|---------|---------------------------------|
  | 33  | 878.35  | C2 Flush Casement               |
  | 52  | 1111.69 | DS2-L101-T102_L                 |
  | 71  | 875.75  | C2 Flush Casement               |
  </code></pre>
  
  <p>I would like to add the Quote number (Which I can get from the file name):</p>
  
  <pre><code>| Id | Price   | Description       | Quote |
  |----|---------|-------------------|-------|
  | 33 | 878.35  | C2 Flush Casement | Q1234 |
  | 52 | 1111.69 | DS2-L101-T102_L   | Q1234 |
  | 71 | 875.75  | C2 Flush Casement | Q1234 |
  </code></pre>
  
  <p>Any pointers would be appreciated.</p>