Stacking multiple columns on to one?
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?

Here is an example as columns:

**Sheet1**

 - apple
 - orange
 - banana

**Sheet2**

 - pineapple
 - strawberry
 - peach

**FinalSheet**

 - apple
 - orange
 - banana
 - pineapple
 - strawberry
 - peach
Stacking multiple columns on to one?
===

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?

Here is an example as columns:

**Sheet1**

 - apple
 - orange
 - banana

**Sheet2**

 - pineapple
 - strawberry
 - peach

**FinalSheet**

 - apple
 - orange
 - banana
 - pineapple
 - strawberry
 - peach