title: Mysql - Manipulating data from a column into rows
body: <p>Please forgive my lack of knowledge, I have been given the chance to progress within work by learning mysql and databases but was given a task of thinking of a project I could work on that would improve things for my colleagues.</p>
  
  <p>What I hope to do is supply them the data in a more usable format.</p>
  
  <p>What I would like to know is there a way that I can take the data that is pulled from the company database in a couple of columns with the same date and time on each row and manipulate it so it displays across several columns. </p>
  
  <p>Sorry my description isn't the best but I hope that the layout below will give a clearer indication of what I'm hoping to do (the bold is the column headings).</p>
  
  <p>Original layout:</p>
  
  <pre><code>date    time    column 1  column 2 
  date 1  time 1  data a    data b            
  date 1  time 1  data c    data d            
  date 1  time 1  data e    data f            
  </code></pre>
  
  <p>Desired Layout:</p>
  
  <pre><code>date    time    column 1  column 2  column 3  column 4  column 5
  date 1  time 1  data a    data b    data c    data e    data f
  </code></pre>
  
  <p>I'm just hoping someone will be able to point me in the right direction of what to research - my Google searches have not come up with anything I can use but there again I'm probably not asking the right worded question.</p>
  
  <p>Again apologies for my ignorance but as name suggests I am a complete newbie.</p>