title: Breakdown (un-group by) multiple column in SQL
body: <p>My new data is <code>grouped by</code> from it's source, so is there any code that can breakdown or un-group the data then assign its value based on what column it was grouped. </p>
  
  <p>the table looks like this</p>
  
  <pre><code>| age | education | city | male | female
  
  | 28  | Secondary |  x   |  0   |   2
  | 28  | University|  x   |  1   |   2
  | 29  | Primary   |  y   |  1   |   0
  </code></pre>
  
  <p>i want the code do something like this</p>
  
  <pre><code>| age | education | city | gender |
  
  | 28  | Secondary |  x   | female |
  | 28  | Secondary |  x   | female | 
  | 28  | University|  x   |  male  |
  | 28  | University|  x   | female |
  | 28  | University|  x   | female |
  | 29  | Primary   |  y   |  male  |
  </code></pre>