title: Split row into multiple rows Oracle
body: <p>I have a table with 5 columns: ID, ERROR1, ERROR2, ERROR3, ERROR4.</p>
  
  <p>A small sample would look like:</p>
  
  <pre>
  ID | Error 1 | Error 2 | Error 3 | Error 4 |
  12 | YES     | (null)  |  (null) | YES |
  15 |  (null) | YES     |  (null) | YES |
  </pre>
  
  <p>So, I need to understand how to break a single row of data where there are multiple columns with "Yes" and turn it into multiple instances of the same ID, and only a single column reading Yes for that instance. So two records of 12 and two records of 15, each having only one error and the rest Null for any individual row. </p>
  
  <p>Thank you</p>