To use an example, I have 2 columns of data that I need to combine into 1...
This is the data I have:
| Column A | Column B |
|---|---|
| Blue | Red |
| Yellow | Green |
This is what I want the formula to do:
| Column A |
|---|
| Blue |
| Yellow |
| Red |
| Green |
Tried searching on Google but results keep showing merge and concatenate. Maybe this is because I can't word it correctly...
I've tried ={Column A, Column B etc.} and FILTER() but I appear to be way off
CodePudding user response：
To copy all values into a different column, use flatten(), like this:
=flatten(A1:B)
That gets values in a rows-first order. To get them in a columns-first order, use query() and an 