title: Unpivot aggregated fields and adding to an existing column in Redshift
body: <p>PLEASE VIEW IMAGE FIRST
  I have the top table with 5 columns.
  The yellow ones are results of a SUM operator.
  I would like to add them as rows to &quot;product_line&quot; and the appropriate values (as in the bottom image).</p>
  <p>UNPIVOT was my first option but I'm not able to add the unpivoted values to an existing column.
  I would love to get help on this.</p>
  <p><a href="https://i.stack.imgur.com/t7XAm.png" rel="nofollow noreferrer">[1]: https://i.stack.imgur.com/4yIPj.png</a></p>