title: Displaying rows as Columns in table
body: <p>I have a Table Like Below</p>
  
  <pre><code>CREATE TABLE Statistics(Stat_Id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
                          Period  VARCHAR(55),
                          Location VARCHAR(255),
                          Rate_per_SqFt INT)
  </code></pre>
  
  <p>The Datas in the Table are</p>
  
  <pre><code>INSERT INTO Statistics(Period, Location, Rate_per_SqFt)
                  VALUES('June', 'Location A', 2500),
                        ('June', 'Location B', 2740),
                        ('June', 'Location C', 3200),
                        ('July', 'Location A', 2650),
                        ('July', 'Location B', 2800),
                        ('July', 'Location C', 3250),
                        ('August', 'Location A', 2750),
                        ('August', 'Location B', 2950),
                        ('August', 'Location C', 3230),
                        ('October', 'Location A', 2950),
                        ('October', 'Location B', 3950),
                        ('October', 'Location C', 3530);
  </code></pre>
  
  <p>I want the Rows for Particular Month Displayed in Output as Separate Columns as Below</p>
  
  <pre><code> Period   Location A     Location B     Location C 
   June        2500          2740           3200
   July        2650          2800           3250
   August      2750          2950           3230
   October     2950          3950           3530  
  </code></pre>
  
  <p>How can I do this using Query</p>