title: Excel Copy and Pasting data into multiple cells
body: <p>I have an Excel question that comes in two parts: Firstly, if I would like to copy data from one worksheet to another where Sheet 1 has:</p>
  
  <pre><code>A
  B
  C
  D
  E
  </code></pre>
  
  <p>and for Sheet 2 I want every cell to repeat thrice such that when I paste the previous five cells into Sheet 2, each cell appears thrice:</p>
  
  <pre><code>A
  A
  A
  B
  B
  B
  C
  C   
  C
  D
  D
  D
  E
  E
  E
  </code></pre>
  
  <p>How do I do that? I personally do now know of any formula or function that can let me do that so really looking forward to your advice. </p>
  
  <p>Once that is done, is there a way to write it up using VBA? I am very very new to VBA and was just thinking if it is possible. Otherwise, I will just record a macro. Thank you very much! </p>