title: VBA cut every other row to last row in column and paste to new column, then delete empty rows
body: <p>hoping to get some help. I'm pretty novice with VBA, especially with loops. I've got data of varying lengths that that will be in column A that consists of an error string (A1,A3,A5,...) and corresponding error message (A2,A4,A6,...).</p>
  
  <p>I'd like to cut the error message data (A2,A4,A6,...) and paste that into column H (H1,H3,H5,...) until the last row of data in column A. I would then like the newly emptied rows (2,4,6,...) to be deleted so I have a table of the error string in column A I can use 'Text to Column' on, and the corresponding error message in column H.</p>
  
  <p>The end goal is that after doing a 'Text to Column', I will have a block of data that I can turn into a table.</p>
  
  <p>If you think there is a better method than the cut-paste-delete empty row method then I'm all ears. I'd also like to bother you less so if you have a good resource for building loops of X code to the last row I'd love that as well.</p>