title: MySQL Query to use to change table orientation (vertical to horizontal)
body: <p>So I have this table:</p>
  
  <pre><code>Year | MonthInterval | RainfallIndex
  2016 | Jan-Feb       | 1.03
  2016 | Feb-Mar       | 0.23
  2016 | Mar-Apr       | 2.30
  </code></pre>
  
  <p>What query can I apply to transform the table into this:</p>
  
  <pre><code>Year | Jan-Feb | Feb-Mar | Mar-Apr 
  2016 | 1.03    | 0.23    | 2.30 
  </code></pre>