title: Matrix view generated from two selected columns of a table
body: <p>Suppose i have a table containing <code>Project_type</code>, <code>Project_No</code>, <code>OS_Platform</code> columns. Here I have limited <code>Project_type</code>s and limited <code>OS_Platform</code>s. I want a database view which produces a matrix between <code>Project_type</code> and <code>OS_Platform</code>.</p>
  
  <pre><code> MY_TABLE : 
   Project_Type     Project_No       OS_Platform 
   Drivers          345              Linux
   WebService       453              Windows                    
   Drivers          034              Windows            
   Drivers          953              Solaris
   DesktopApp       840              Windows 
   WebService       882              Solaris   
  </code></pre>
  
  <p>Now I have <code>Project_type</code> and <code>OS_Platform</code> as selected columns. I want a matrix view of these two columns with distinct rows and column names.</p>
  
  <pre><code>Project_Type     Linux    Windows     Solaris
  WebService       null      true         true
  Drivers          true      true         true
  DesktopApp       null      true         null
  </code></pre>
  
  <p>Can anyone tell me if it is possible. How is that possible ?</p>