title: teradata concatenating rows based on a column
body: <p>I have a table like below</p>
  
  <pre><code>Cstmr_ID | PPM | prepaid |home_phone|srvc_num
  1        |Y    |N        |N         |0422222222
  1        |Y    |N        |N         |0433333333
  1        |N    |N        |Y         |0333333333 
  2        |y    |N        |N         |0455555555
  2        |N    |N        |Y         |0355555555
  </code></pre>
  
  <p>Now I want a table like this.</p>
  
  <pre><code>Cstmr_id  | PPM_srvc_num         |prepaid_srvc_num|home_phone_srvc_num
  1         |0422222222,0433333333 |                |0333333333
  2         |0455555555            |                |0355555555
  </code></pre>