How do I transform this data set using SQL? : <p>How do I write SQL that will transform data set 1 into data set 2?</p>

<blockquote>
  <p>Data Set 1</p>
</blockquote>

<pre><code>id  Name                    Home_Phone      Work_Phone      Mobile_Phone
--- ----------------------- ------------    ------------    ------------
44  Mary James              NULL            NULL            333-832-1066
44  Mary James              111-747-7048    NULL            NULL
46  James Smith             NULL            NULL            111-354-2092
46  James Smith             111-737-8936    NULL            NULL
45  Shelley Berlin          NULL            NULL            222-960-5115
45  Shelley Berlin          NULL            222-845-2422    NULL
39  Brad Saito              NULL            NULL            NULL
39  Brad Saito              Invalid         Invalid         Invalid
55  Debbie Peters           NULL            NULL            NULL
55  Debbie Peters           NULL            NULL            NULL
55  Debbie Peters           NULL            222-960-7778    NULL
</code></pre>

<blockquote>
  <p>Data Set 2</p>
</blockquote>

<pre><code>id  Name                    Home_Phone      Work_Phone      Mobile_Phone
--- ----------------------- ------------    ------------    ------------
44  Mary James              111-747-7048    NULL            333-832-1066
46  James Smith             111-737-8936    NULL            111-354-2092
45  Shelley Berlin          NULL            222-845-2422    222-960-5115
39  Brad Saito              Invalid         Invalid         Invalid
55  Debbie Peters           NULL            222-960-7778    NULL
</code></pre>
