How to union ranges in google spreadsheets

contributorpw picture contributorpw · May 29, 2012 · Viewed 84.2k times · Source

I want to union ranges from any Google spreadsheets.

The example

Sheet1!A:A

{12, 131, 45}

Sheet2!A:A

{12, 131, 46}

The unknown function

=formula_for_union_range(Sheet1!A:A; Sheet2!:A:A)

should return

{12, 131, 45, 12, 131, 46}

The question

How is it possible?

Answer

mik picture mik · Jun 6, 2016

Just use:

={sheet1!a:a; sheet2!a:a}