Hi Hennesy,
If Table and 2 doesnt have anthing in common, join(condition col of table 1 != col1 of table 2) will result in all the possible combinations for each row of both the tables and in rows starting from first.
Then you can copy the output data table to excel and use remove range for each column of excel to remove duplicate values from it.
Pls refer tot the attached example.
Note this is not the ideal way to do this, because you do not want to use looping, i am suggesting this.