有没有可以将A的所有列合并到B的所有列的功能 [英] Is there a function where I can merge all columns of A to all columns of B

问题描述

我在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 8 B栏-A B C D E F G H

Example: Column A - 1 2 3 4 5 6 7 8 Column B - A B C D E F G H

我想要的结果是 1A 2A 3A 4A 5A 6A 7A 8A 1B 2B 3B 4B 5B直到我达到8H

The result I want is 1A 2A 3A 4A 5A 6A 7A 8A 1B 2B 3B 4B 5B 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的所有列的功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！