title: Need help on PIVOT with NULL value
body: <p>I have this data set, and wanted to do a pivot.</p>
  
  <p><strong>Data</strong></p>
  
  <pre><code>Series_Name         Rec_Id  Series_Value    Point_Color
  Hs avg CVD1 P1A     420     8810            NULL
  Hs avg CVD1 P1B     420     8850.5          NULL
  Hs avg CVD1 P2A     420     8793.5          R
  Hs avg CVD1 P2B     420     8806.5          R
  </code></pre>
  
  <p><strong>Expected result.</strong></p>
  
  <pre><code> Rec_Id Point_Color Hs avg CVD1 P1A     Hs avg CVD1 P1B     Hs avg CVD1 P2A     Hs avg CVD1 P2B
   420    R           8810                8850.5              8793.5              8806.5
  </code></pre>
  
  <p>But at this moment, from what I have try, this is the result I get, I guess it is the NULL and 'R' value on column Point_Color causing it. Please advice how to get the expected result?</p>
  
  <p><strong>Current result I get</strong></p>
  
  <pre><code>Rec_Id  Point_Color Hs avg CVD1 P1A     Hs avg CVD1 P1B     Hs avg CVD1 P2A     Hs avg CVD1 P2B
  420     NULL        8810                8850.5              NULL                NULL
  420     R           NULL                NULL                8793.5              8806.5
  </code></pre>
  
  <p>Thanks in advance.</p>