Gather values from a range to a single column?

Question

Does anyone know how to gather values from a range to a single column? for exempele... i have information in cells A1:C5 and I want those cell to be copied to Column H (H1, H2 and so on....)

Answer 1

I believe your question is pretty much answered here: Stacking multiple columns on to one?

=TRANSPOSE(SPLIT(JOIN(";",A:A,B:B,C:C),";"))

Note that you could equally well just do from row 1 through 5 like this:

=UNIQUE(TRANSPOSE(SPLIT(JOIN(";",A1:A5,B1:B5,C1:C5),";")))

As mentionned by Adam, this will work with the new Google Docs, and is more simple:

={A1:A5;B1:B5;C1:C5}

Answer 2

From the same question Jonathan linked to, I think this answer is now the better one (it is supported in the newest version of Sheets, which wasn't around when that question was first asked).

={A1:A5;B1:B5;C1:C5}