How to Create Single List from Two Ranges in Google Sheets?
In Google Sheet I Have 2 Ranges of Variable Length with Some Data, I. E. Column a: Aa, Ab, Ac; and Column B: Ba, Bb, Bc. I Would Like to Combine Them in One...
In google sheet I have 2 ranges of variable length with some data,i.e.
column A: aa, ab, ac; and
column B: ba, bb, bc.
I would like to combine them in one long list in column C with a some formula:
- column C: aa, ab, ac, ba, bb, bc.
I thought that UNIQUE function could work if it took 2 ranges- but it does not or ARRAYFORMULA but does not look like this is a sensible idea.
So looking for solution or direction.
Thank you!
Marek
If anyone is interested, here is my solution:
To combine two ranges into a single column, join them with curly braces with a semi-colon in-between. Example:
={(A3:A7);(B3:B7)}
In my specific situation I used the following:
=UNIQUE({(A3:A7); (B3:B7)})
Which successfully outputs only the unique values from the joined range.
Thanks!
Maya is a hardware enthusiast who tests and reviews smart home devices, smartphones, wearables, and audio gear. She focuses on practical consumer value and build quality.
