title: Stacking multiple columns on to one?
body: <p>I am using Google SpreadSheet, and I'm trying to have multiple sheets containg a list of words. On the final sheet, I would like to create a summative list, which is a combination of all the values in the column.  I got it sort working using =CONCATENATE() , but it turned it into a string.  Any way to keep it as a column list?</p>
  
  <p>Here is an example as columns:</p>
  
  <p><strong>Sheet1</strong></p>
  
  <ul>
  <li>apple</li>
  <li>orange</li>
  <li>banana</li>
  </ul>
  
  <p><strong>Sheet2</strong></p>
  
  <ul>
  <li>pineapple</li>
  <li>strawberry</li>
  <li>peach</li>
  </ul>
  
  <p><strong>FinalSheet</strong></p>
  
  <ul>
  <li>apple</li>
  <li>orange</li>
  <li>banana</li>
  <li>pineapple</li>
  <li>strawberry</li>
  <li>peach</li>
  </ul>