title: Script for Moving 50 Rows to the Next Column - Excel
body: <p>I have a request for how I might go about the following operation:</p>
  
  <p>I have a csv file (that I'm opening in Excel) that I am appending a block of data 50X2 (rowsXcolumns) to the csv file. With the finished csv file, I would like to automate a process where every 50 rows get selected (both columns) and the data essentially gets cut and copied to the next two available columns. </p>
  
  <p>An example would be data from $A$1:$B$50 is in the csv and then a second sample is taken and the second set of data goes to $A$51:$B$100 and I would like to automatically move the second set to $C$1:$D$50 and perform that move for all samples taken.</p>
  
  <p>I don't know what the best route for this operation would be (macro/VBA/etc) and would like some assistance with this, if it is easily possible.</p>
  
  <p>Thank you all for your time and help.</p>