Concatenate All Possible Combinations
I have a spreadsheet with 2 columns. I would like to concatenate each row in
column A with all rows in column B into another sheet. The columns are
different lengths and are between 50 and 150 rows long.
Example:
Column A Column B
Dog Red
Cat Brown
Sheep Yellow
Horse
In sheet 2
Column A
Dog €“ Red
Dog €“ Brown
Dog €“ Yellow
Cat €“ Red
Cat €“ Brown
Cat €“ Yellow
Sheep €“ Red
Sheep €“ Brown
Sheep €“ Yellow
Horse €“ Red
Horse €“ Brown
Horse - Yellow
Help please. Thank you.
|