Excel VBA code to transpose data from rows to columns
<p>I have data in column A with 50000 rows of data. I need to transpose every 6 rows of data to 6 columns. For example data from A1:A6 must be transposed to B1:G1. Again data from A7:A14 must be transposed to B2:G2. I appreciate if anyone can provide VBA code for this.</p>

<blockquote>
  <p>Data I have in column A is as shown below:</p>
</blockquote>

<pre><code>Col A
1
2
3
4
5
6
7
8
9
10
11
12
</code></pre>

<blockquote>
  <p>The transpose data must be as shown below in col B to col G:</p>
</blockquote>

<pre><code>Columns  B   C   D   E   F   G
         1   2   3   4   5   6
         7   8   9   10  11  12
</code></pre>