Create an array of results from data from 2 columns
$15-20 USD
已完成
已发布大约 12 年前
$15-20 USD
货到付款
I have an excel with, lets say, the following text:
Column A
worda1
worda2
worda3
worda4
worda5
Column B
wordb1
wordb2
wordb3
wordb4
wordb5
The results I'm trying to get is an array of the combination of values between both Column A and Column B. The correct results would be
Column C
worda1 wordb1
worda2 wordb1
worda3 wordb1
worda4 wordb1
worda5 wordb1
worda1 wordb2
worda2 wordb2
worda3 wordb2
worda4 wordb2
worda5 wordb2
worda1 wordb3
worda2 wordb3
worda3 wordb3
worda4 wordb3
worda5 wordb3
worda1 wordb4
worda2 wordb4
worda3 wordb4
worda4 wordb4
worda5 wordb4
worda1 wordb5
worda2 wordb5
worda3 wordb5
worda4 wordb5
worda5 wordb5
Anyone know of the best way to do this within excel or would this rather be best written as a small program?
Best answer wins