CODEWITHSUNDEEP
google-sheets
gespinha
gespinha

Reputation: 8487

Union between two arrays in Google Sheets

I've got the following tables:
First 1
Second 2
Third 3
Fourth 4

I want to build a formula that bring both together vertically, so that I end up with a big table like this:
First 1
Second 2
Third 3
Fourth 4

I've tried using standard union formulas like {table1, table2} but it adds table2 horizontally, not vertically.

Any thought on how I would go about doing this?

Upvotes: 1

Views: 605

Answers (2)

Kate
Kate

Reputation: 1533

When using curly braces, a comma ({table1, table2}) separates data into columns on the same row, while a semi-colon ({table1; table2}) will put table2's data into the row after table1's data.

Upvotes: 4

Mike Steelson
Mike Steelson

Reputation: 15308

I presume that your local parameters will ask you tu write it as following

{table1; table2}

Upvotes: 0

Related Questions