'Create single list/column from multiple tables in Excel
I want to combine the values in two tables into a single list - what function does this?
Solution 1:[1]
Courtesy chris-neilsen:
=FILTERXML("<t><s>"&TEXTJOIN("</s><s>",TRUE,B2:C3)&"</s><s>"&TEXTJOIN("</s><s>",TRUE,E2:F3)&"</s></t>","//s[not(preceding::*=.)]")
Note: this addresses the original [pre-revision] Q which stipulated unique values should be output, to reproduce all values incl. duplicates this function becomes: FILTERXML("<t><s>"&TEXTJOIN("</s><s>",TRUE,B2:C3)&"</s><s>"&TEXTJOIN("</s><s>",TRUE,E2:F3)&"</s></t>","//s")
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |