title: Text File Manipulation Using Python or Unix
body: <p>I have a very large text file with data in it but it is not in a form that I need for input into additional tools.  For some reason I just can't get the code right.  The file is too large to open in Excel for modification.</p>
  
  <p>This is what I have:</p>
  
  <p><a href="https://i.stack.imgur.com/uLo9i.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uLo9i.png" alt="enter image description here"></a></p>
  
  <p>This is what I need:</p>
  
  <p><a href="https://i.stack.imgur.com/5JBbJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5JBbJ.png" alt="enter image description here"></a></p>
  
  <p>Any help is greatly appreciated!  Thanks in advance.</p>