title: SQL - Nested Columns possible?
body: <p>I'm fairly au fait with SQL but there is one thing I'm not sure is possible so I thought I'd give it a go asking another queston on here.</p>
  
  <p>I have the need to return "Countries" as each row, and then have 3 columns for each Country which records an average of percentages from another table. This is fine, I can do this without problem.</p>
  
  <p>The place I am stuck is that, I want the 3 columns per row to be repeated for, let's say, each month. So, effectively, I want the 3 columns to be nested under a higher level column which contains the month name. The layout I need is below (the column "Index" is a calculation of the percentage in the Company1/2 columns)</p>
  
  <pre><code>      |         January            | 
  </code></pre>
  
  <p>Country|Company 1|Company 2|Index|</p>
  
  <p>Is this even possible?</p>