I have the following ranges:
| range1 |
|---|
| 1 |
| 2 |
| range2 |
|---|
| 3 |
| 4 |
How to concatenate them to get:
| range3 |
|---|
| 1 |
| 2 |
| 3 |
| 4 |
I tried "Consolidate" - but it is not what I need.
I also read this guide https://support.microsoft.com/en-us/office/guidelines-and-examples-of-array-formulas-7d94a64e-3ff3-4686-9372-ecfd5caa57c7. But didn't manage to find an answer there
In Microsoft365 you could use:
Formula in D1:
=FILTERXML("<t><s>"&TEXTJOIN("</s><s>",,A:A,B:B)&"</s></t>","//s")
Where A:A is a placeholder for you 1st range and B:B for your 2nd range. Also see this answer by @BigBen which shows the idea of "flattening" multiple columns although his query continues pulling unique values only.
