|
2学分
本帖最后由 lypcom123 于 2021-12-15 22:59 编辑
请教大佬,如何用公式右拉把下面的多行合为一行,绿色背景的不要,不能改变顺序,就是要变成右边的样子: | 3 | 2 | 1 | 8 | 5 | 3 | 9 | A | 4 | B | H | B | | | | | | | | | | | | | | | | | | 3 | 2 | 1 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 这 | 有 | 内容 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 但不 | 合并 | | | | | | | 很明显,用下面的公式右拉不行,因为中间出现了不要想要的内容 | | | | | | | | | | | | | | | 8 | 5 | 3 | | | | | | 3 | 2 | 1 | 这 | 有 | 内容 | 但不 | 合并 | 0 | 8 | 5 | 3 | 11111 | 77777 | 9999 | 0 | 0 | 0 | 9 | A | 4 | 111 | 1111 | 0 | 0 | 0 | 0 | B | H | B | 11111 | 77777 | 9999 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 9 | A | 4 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 111 | 1111 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | B | H | B | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
=OFFSET($A$2,FLOOR(COLUMN(A1)-1,3),MOD(COLUMN(A1)-1,3))
祝順心,南無阿彌陀佛!
|
最佳答案
查看完整内容
=OFFSET($A$2,FLOOR(COLUMN(A1)-1,3),MOD(COLUMN(A1)-1,3))
祝順心,南無阿彌陀佛!
|