title: Link Vertical Data to Horizontal Data
body: <p>I've got a load of data in Sheet2 that goes down vertical in Column C.  On Sheet1 I would like to put the horizontally.
  ie.</p>
  
  <p><strong>Sheet 2</strong></p>
  
  <pre><code>C1 = A 
  C2 = B 
  C3 = C
  </code></pre>
  
  <p><strong>Sheet1</strong></p>
  
  <pre><code>E20 = A
  F20 = B
  G20 = C
  </code></pre>
  
  <p>Does anyone know how I can accomplish this?
  I tried =TRANSPOSE(Overview!$C:$C) but no joy</p>