title: PL/SQL convert rows to grouped columns
body: <p>I'm not sure how to phrase this question, but I am trying to convert a row value into columns in PL/SQL.  I'm not a newbie, but I just can't figure how to go about doing this.  I have the following table data:</p>
  
  <p>Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Responsibility</p>
  
  <hr>
  
  <p>Joe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sales<br/>
  Steve&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sales<br/>
  Paul&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Exec<br/>
  Pete&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Manager<br/>
  John&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Exec<br/>
  Roger&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sec<br/>
  Scott&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Exec<br/>   </p>
  
  <p>I need to create a query that will return and display the data as follows:</p>
  
  <p>Sales&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Manager&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Exec&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sec</p>
  
  <hr>
  
  <p>Joe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Pete&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;John&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Roger<br/>
  Steve&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Scott&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Null<br/>
  Null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Paul&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Null</p>
  
  <p>The problem I am facing is that the row data is not related to eachother in anyway. Can this even be done?</p>
  
  <p>I appreciate any help anyone can offer on this.
  Thanks.</p>