google-sheets - 通过在 Google 表格中添加新行将 2 列合并为一列

Question

我可以使用哪个公式在 Google 表格中实现这一目标？

从：

Column  1 | Column 2
   1      |    2
   3      |    4

至：

1

2

3

4

标签： google-sheetsgoogle-sheets-formula

Answer 1

=ARRAYFORMULA(QUERY(TRANSPOSE(SPLIT(QUERY(TRANSPOSE(QUERY(TRANSPOSE(IF(A:B<>"", A:B&"♦", ))
 ,,999^99)),,999^99), "♦")), "where Col1 is not null"))

---

=ARRAYFORMULA(QUERY(TRANSPOSE(SPLIT(QUERY(TRANSPOSE(QUERY(TRANSPOSE(
 IF(A:B<>"", A:B&"♦ ♦", )),,999^99)),,999^99), "♦")), "limit "&COUNTA(A:B)*2-1))