title: Insert data based on sequence number
body: <p>I have the following data in a table:</p>
  
  <pre><code>Index   Domain  Name
  -------------------------
  1       AAA     Aaron.B
  NULL    NULL    NULL
  1       AAA     Aaron.B2
  NULL    NULL    NULL
  NULL    NULL    NULL
  NULL    NULL    NULL
  NULL    NULL    NULL
  NULL    NULL    NULL
  NULL    NULL    NULL
  2       AAA2    Aaron.D
  NULL    NULL    NULL
  NULL    NULL    NULL
  NULL    NULL    NULL
  </code></pre>
  
  <p>What I would like to achieve is the following:</p>
  
  <pre><code>Index   Domain  Name
  ------------------------------
  1      AAA      Aaron.B
  1      AAA      Aaron.B
  1      AAA      Aaron.B2
  1      AAA      Aaron.B2
  1      AAA      Aaron.B2
  1      AAA      Aaron.B2
  1      AAA      Aaron.B2
  1      AAA      Aaron.B2
  1      AAA      Aaron.B2
  2      AAA2     Aaron.D
  2      AAA2     Aaron.D
  2      AAA2     Aaron.D
  2      AAA2     Aaron.D
  </code></pre>
  
  <p>Any assistance and offered explanation would be greatly appreciated.</p>
  
  <p>Regards,
  John</p>