根据每一行将四列合并为一列 [英] Join four columns into one according to each row

问题描述

A B C D
E F G H
I J K L
M N O P

如果我选择加入列，我会 = {A1:A; B1:B; C1:C; D1:D} ，但它看起来像这样:

If I chose to join the columns I would ={A1:A;B1:B;C1:C;D1:D} but it would look like this:

A
E
I
M
B
F
J
N
... and so on

我希望它看起来像这样:

I would like it to look like this:

A
B
C
D
E
F
G
... and so on

在这种情况下如何进行?

How to proceed in this case?

注意:可能会发生某些列的数据不完整，某些列可能比其他列具有更多值的情况，但是我仍然希望继续遵循相同的模式.示例:

Note: It may happen that some of the columns are not complete in data, some may have more values than the others, but I still want to continue following this same pattern. Example:

A B   D
E   G H
I J K L
M N O P

结果:

A
B
D
E
G
H
... and so on

推荐答案

使用:

=TRANSPOSE(QUERY(TRANSPOSE(A:D),, 9^9))

然后:

=TRANSPOSE(SPLIT(QUERY(TRANSPOSE(QUERY(TRANSPOSE(A:D),,9^9)),,9^9), " "))

这篇关于根据每一行将四列合并为一列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！