K
Kevin199
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.
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.