本文介绍了根据每一行将四列合并为一列的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
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), " "))
这篇关于根据每一行将四列合并为一列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!