在excel中添加/组合两组数据

问题描述：

我有两组数据（大数字）。 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;

i have two set of data (large numbers).

&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;
set-A

set-A

set-B

我希望以这样的方式组合两个集合，即set-A的row2下面的set-B的row2，set-A的row3下面的set-B的row3，依此类推。 ie

i want to combine two set in such a way that row2 of set-B below row2 of set-A, row3 of set-B below row3 of set-A and so on. i.e.

答

您是否正在寻找可以运行以填充新单元格的宏？或者您在新单元格中输入的公式，以从任何一组数据中获取数据？

Are you looking for a macro you can run to fill the new cells? Or a formula you enter in the new cells to get the data from whichever set of data?

在excel中添加/组合两组数据

相关推荐