title: MS Excel copy integers on same spreadsheet
body: <p>I have integers that are copied into an excel spreadsheet:</p>
  
  <pre><code>1
  2
  3
  4
  5
  6
  7
  8
  9
  10
  </code></pre>
  
  <p>With some formula, I'd like those to be copied to somewhere else on the same
  excel sheet. =a1:a10 doesn't do anything helpful and only reports one of the values, just the a1 field.</p>
  
  <p>What's the trick to have the data copied to a different set of fields?</p>
  
  <p>I've tried =text(a1:a10), =CONCATENATE(a1:a10), rows, columns </p>
  
  <p>So point and laugh at me, but PLEASE tell me what's the simple trick to duplicate data on the same exact spreadsheet!</p>
  
  <p>edit...
  This will work if I do =e4 in one cell followed by =e5, =e6 all in their own cells, but I still need to have commas between each value. For example:
  1,2,3,4,5,6,7,8,9,10.</p>
  
  <p>As you see below, the CONCATENATE worked for me.</p>
  
  <p>Thanks!</p>