title: Transposing data from column to row using references
body: <p>I have some data in a row, say A1 to Z1, and I would like to link to this data in another spreadsheet. However I would like to transpose it so the data runs from A1 to A26. It is important that it is linked in some type of function so that if I change the data on the first sheet, the second sheet is updated as well.  </p>
  
  <p>I'm thinking of some type of formula that states that as you go down a cell in column A, it knows to grab the data from the next cell to the right in Row 1. So: A2=B1; A3=C1; A4=D1 ...  </p>
  
  <p>Any ideas?</p>