Create an array of results from data from 2 columns

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