title: Writing a Macro to Use the Transpose Function for strings of text
body: <p>I am trying to move rows of text into one column in Excel that's in a new Sheet. The transpose function works well, but will only move one row at a time. I would like to get a macro that will convert thousands of rows of data across multiple columns into one column. Please see example below (I've separated each column in the row by semi-colons). Thanks in advance for any help.</p>
  
  <p>Rows:</p>
  
  <pre><code>Avila P, 2005, CHEM ENG J; Barbero BP, 2008, CHEM ENG J; Crookes R, 2004, SERIES MAT SUS APLIC
  Duran FG, 2009, APPL CATAL B-ENVIRON;  Amini SK, 2004, CHEM PHYS LETT
  Ali MH, 2005, SYNTHESIS-STUTTGART; Arya P, 2001, CURR OPIN CHEM BIOL; Balunas MJ, 2008, J NAT PROD
  </code></pre>
  
  <p>Column:</p>
  
  <pre><code>Avila P, 2005, CHEM ENG J
  Barbero BP, 2008, CHEM ENG J
  Crookes R, 2004, SERIES MAT SUS APLIC
  Duran FG, 2009, APPL CATAL B-ENVIRON
  Amini SK, 2004, CHEM PHYS LETT
  Ali MH, 2005, SYNTHESIS-STUTTGART
  Arya P, 2001, CURR OPIN CHEM BIOL
  Balunas MJ, 2008, J NAT PROD
  </code></pre>