I want to union ranges from any Google spreadsheets.
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}
How is it possible?
Just use:
={sheet1!a:a; sheet2!a:a}