title: How to split a table in excel VBA
body: <p>I have the following table</p>
  
  <pre><code>id  name    attribute1  attribute2  attribute3
  1   mike    red            white       red
  2   hike    black          red         black
  3   nike    green          green       blue
  </code></pre>
  
  <p>I want to apply ALL attributes to each <code>id and name</code> rows like this</p>
  
  <pre><code>id  name    attribute1  attribute2  attribute3
  1   mike    red            white       red
  1   mike    black          red         black
  1   mike    green          green       blue
  2   hike    red            white       red
  2   hike    black          red         black
  2   hike    green          green       blue
  3   nike    red            white       red
  3   nike    black          red         black
  3   nike    green          green       blue
  </code></pre>
  
  <p>How can I do this?</p>