title: Toad for Oracle- Reshape Wide to Long
body: <p>I am trying to transpose a data set from wide to long.  Ive done this is SAS but am new to this. Ideally I want one unique row per ID and code.  Not sure if it can be done in one step or multiple, either way would be fine with me.  My data looks something like this.</p>
  
  <pre><code>ID   code1   code2   code3
  1     abc     def     ghi
  1     abc     xyz     def
  2     zyx     abc     mno
  </code></pre>
  
  <p>AND I want it to look like</p>
  
  <pre><code>ID  Code_concat
  1   abc
  1   def
  1   ghi
  1   xyz
  2   zyx
  2   abc
  2   mno
  </code></pre>
  
  <p>Any advice would be greatly appreciated, thanks!</p>