title: PIVOT and insert every N rows
body: <p>There are two tables:</p>
  
  <p>First table has two columns with the following data:</p>
  
  <pre><code>[col1] [RowIndex]
  apple  1
  10     2
  red    3
  pear   4
  20     5 
  yellow 6
  </code></pre>
  
  <p>Second empty table has 3 columns:</p>
  
  <pre><code>[FruitType] [Weight] [Color] 
  </code></pre>
  
  <p>I wish to load the first table's [col1] data into the second one but "rotated" and without any aggregation.</p>
  
  <p>Result would would look like this:</p>
  
  <pre><code>[FruitType] [Weight] [Color] 
  apple        10       red
  pear         20       yellow
  </code></pre>
  
  <p>How can i insert data to the second table? I tried PIVOT but cannot wrap my head around.</p>