title: Excel Macro - Trying to grab 5 rows place in 5 horizontal spaces and stack on top of each other
body: <p>I have one column of data which has 1 word translated under it 4 times. Then this repeats all down the column. What I want to have is 4 columns with each language translation in each one. They are stacked on top of each other at the moment. I have tried a Macro but can't seem to get it to loop.</p>
  
  <pre><code>Range("B3").Select
  Selection.Cut
  Range("C2").Select
  ActiveSheet.Paste
  Range("B4").Select
  Selection.Cut
  Range("D2").Select
  ActiveSheet.Paste
  Range("B5").Select
  Selection.Cut
  Range("E2").Select
  ActiveSheet.Paste
  Range("B6").Select
  Selection.Cut
  Range("B3").Select
  ActiveSheet.Paste
  Range("B7").Select
  Selection.Cut
  Range("C3").Select
  ActiveSheet.Paste
  Range("B8").Select
  Selection.Cut
  </code></pre>
  
  <p>Is it best to use cut and then move the first column up and repeat the same action?</p>
  
  <p>Attached image of data on left and how it should look on right. Appreciate any pointers, thanks.<a href="https://i.stack.imgur.com/2n118.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2n118.jpg" alt="enter image description here"></a></p>