问题描述
我在Excel中遇到一种情况,我想将A列的所有值组合到B列的所有值(在这里我想将B的所有值都绝对保留为A列的所有值)
I have a situation in Excel where I want to combine all values of column A to to all values of column B (where I want to keep all values of B Absolute to All values of column A)
示例:列A-1 2 3 4 5 6 7 8B栏-A B C D E F G H
Example:Column A - 1 2 3 4 5 6 7 8Column B - A B C D E F G H
我想要的结果是1A2A3A4A5A6A7A8A1B2B3B4B5B直到我达到8H
The result I want is1A2A3A4A5A6A7A8A1B2B3B4B5B so on till I reach 8H
我尝试了简单的串联,但是显然花费的时间太长了
I have tried simple concatenating but obviously it is taking too long
如果有人可以调查一下并为我提供一个公式来帮助解决此问题,将不胜感激.
It would be appreciated if someone can look into this and provide me with a formula to help me fix this.
致谢
推荐答案
发布后,我意识到您真正追求的是什么.
After your post, I realized what you are really after.
在单元格C1
中放置:
=IF(ROW()-ROW($C$1)+1>COUNTA(A:A)*COUNTA(B:B),"",INDEX(A:A,INT((ROW()-ROW($C$1))/COUNTA(B:B)+1))&INDEX(B:B,MOD(ROW()-ROW($C$1),COUNTA(B:B))+1))
然后向下拖动
这篇关于有没有可以将A的所有列合并到B的所有列的功能的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!