Concatenating All Combinations From Two Lists

Column A has a list of items beginning in A2:
1
4
11
29
109
234

Column B has another list of items beginning in B2:
CAR
BOAT
TRUCK

Would like to put a list in column D, starting at D1, that concatenates both lists like this:
1CAR
1BOAT
1TRUCK
4CAR
4BOAT
4TRUCK
11CAR
11BOAT
11TRUCK
etc until all combinations have been covered.

Notes:
-Both lists can vary in number of items
-Both lists will never have a blank cell until the end of the list

I am thinking of a looping macro to do this, perhaps a loop within a loop? But I am stumped how to go about this.

I know this should be done in Access. but I need to do it in Excel.