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?
Type =CONCAT ( to begin your formula. Type the address of the first cell that you want to combine with, such as A2. Type a comma, and then type the address of the next cell that you want to combine with, such as B2. Press enter on the keyboard.
Combine Two Query Results Vertically in Google Sheets Just place the semicolon between the two Query formulas and then wrap the entire formula with the Curly Brackets. It would work in most of the cases. But if either of the formulas returns an #N/A (empty output) then the combined formula would return an #VALUE!
Select the rows or columns that you want to group. You can do this easily by dragging through them. Then, right-click and choose the Group option for the rows or columns you selected.
Just use:
={sheet1!a:a; sheet2!a:a}
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With