I have 2 columns of data, each with variable length:
C1 C2
a x
b y
c z
d
I need to create a cross-product of these text fields that would provide the following:
ax
ay
az
bx
by
bz
cx
cy
cz
dx
dy
dz
Is there a formula in Excel or a VBA macro that could produce this?
Thanks.
MD