title: Need to transform the rows into columns for the similar ID's in oracle
body: <p>I need to transform the rows into columns for the similar ID's in oracle</p>
  
  <p>e.g.
  The following is the result I will get if i query my database</p>
  
  <pre><code>Col1    Col2      Col3 
  ----    ----      ----
  1        ABC       Yes
  1        XYZ       NO
  2        ABC       NO
  </code></pre>
  
  <p>I need to transform this into </p>
  
  <pre><code>Col1    Col2    Col3       Col4        Col5
  ----    ----    ----       ----        ----
  1        ABC     Yes        XYZ          No
  2        ABC     NO        NULL        NULL
  </code></pre>
  
  <p>Someone please help me in solving this issue</p>
  
  <p>Thanks,
  Siv</p>