I need to pair each item on one list to each item on another list

P

Peter R.

I need to pair each item on one list to each item on another list. For
example, if I have a list:

A
B
C

And another list:

D
E
F

What I need is one list as follows:

AD
AE
AF
BD
BE
BF
CD
CE
CF

Is there a simple way to do this, instead of a lot of copy and paste?

Thanks!

Peter R.
 
M

Max

Assuming the 2 lists are housed within A1:B3, viz:

A D
B E
C F

Put in C1:
=OFFSET($A$1,INT((ROW(A1)-1)/3),)&OFFSET($B$1,MOD(ROW(A1)-1,3),)
Copy down to C9
 
Top