title: Transform vertical address list to horizontal list on Excel 2010
body: <p>A simple question, but one where i have found an answer to yet. I have a  large list of addresses in vertical format that i want to change to a horizontal list. Below is an example, basically i want to change the cells to read accross horizontal rather than down vertically, cell values for each section in brackets:</p>
  
  <p>Vertical list:</p>
  
  <pre><code>(A1) 12 Norton Street
  (A2) Warwick
  (A3) Warwickshire
  (A4) CV12 3SE
  </code></pre>
  
  <p>Horizontal list:</p>
  
  <pre><code>(A1) 12 Norton Street  (B1) Warwick  (C1) Warwickshire  (D1)CV12 3SE
  </code></pre>
  
  <p>Anyone have any suggestions?</p>