title: Inverting columns and rows
body: <p>I have this query</p>
  
  <pre><code>SELECT 
      PA.PK, PA.PACKAGE_NAME, ATTR.ENGLISH_NAME ATTRIBUTES, 
      PA.VALUE, ATTR_LIST.ENGLISH_NAME ATTRIBUTES_LIST
  FROM 
      POSTS_ATTRIBUTES PA 
  INNER JOIN 
      POSTS P ON PA.POSTS = P.PK
  LEFT OUTER JOIN 
      ATTRIBUTES ATTR ON PA.ATTRIBUTES = ATTR.PK
  LEFT OUTER JOIN 
      ATTRIBUTES_LIST ATTR_LIST ON PA.ATTRIBUTES_LIST = ATTR_LIST.PK
  WHERE 
      P.FIELDS  = 83;
  </code></pre>
  
  <p>Which gives output like this</p>
  
  <pre><code>PK | PACKAGE_NAME | ATTRIBUTES            | VALUE  | ATTRIBUTES_LIST 
  ------------------------------------------------------------------
  211| CERAMICS     | RAW MATERIALS         | (null) | CEMENT 
  212| CERAMICS     | PRODUCTION OPERATIONS | (null) | PRESSING 
  213| CERAMICS     | OPERATIONAL SERVICES  | (null) | FORK LIFTS RENTAL 
  214| CERAMICS     | FINISHED PRODUCTS     | (null) | FLOOR CERAMICS
  </code></pre>
  
  <p>Is there any way to invert columns and rows via a query to make it looks like </p>
  
  <pre><code>PACKAGE_NAME | RAW MATERIALS | PRODUCTION OPERATIONS | OPERATIONAL SERVICES | FINISHED PRODUCTS 
  ---------------------------------------------------------------------------------------------------
  CERAMICS     |    CEMENT     |      PRESSING         |   FORK LIFTS RENTAL  |  FLOOR CERAMICS
  </code></pre>