title: Excel/VBA: Transpose and "Flush" Table
body: <p>I would like to automate the following process:  </p>
  
  <ol>
  <li>There's a table of data that I want to transpose.</li>
  <li>Then "flush left".  </li>
  </ol>
  
  <p>The number of rows and columns will increase as time goes by. The screenshot below should explain better (using SkyDrive): <a href="http://sdrv.ms/UdDu1o" rel="nofollow noreferrer">http://sdrv.ms/UdDu1o</a></p>
  
  <p><img src="https://i.stack.imgur.com/eYBCm.jpg" alt="enter image description here"></p>
  
  <p>The only way I could think about doing this was using <code>VBA</code>, via <code>pastespecial-transpose</code> and lots of <code>do-while</code> statements to find the start and end of the row before copying. I understand copy and paste tend to slow down VBA programs - does anyone have any better suggestions?</p>