title: Processing CSV data
body: <p>I have recently been asked to take a .csv file that looks like this:</p>
  
  <p><img src="https://i.stack.imgur.com/ASSvl.png" alt="enter image description here"></p>
  
  <p>Into something like this:</p>
  
  <p><img src="https://i.stack.imgur.com/gY8J1.png" alt="enter image description here"></p>
  
  <p>Keeping in mind that there will be hundreds, if not thousands of rows due to a new row being created every time a user logs in/out, and there will be more than simply two users. My first thought was to load the .csv file into a MySQL then run a query on it. However, I really don't want to install MySQL on the machine that will be used for this.</p>
  
  <p>I could do it manually for each agent in Ecxel/Open Office, but due to there being little room for error, and there are so many lines to do this, I want to automate the process. What's the best way to go about that?</p>