Combine and Multiply/Permutate/Mix Words

[PipSqueakables]

Hi

How do I mix words together like for e.g. this:

1st Column
WordA
WordB
WordC

2nd Column
Word1
Word2

Results:
WordA Word1
WordA Word2

WordB Word1
WordB Word2

WordC Word1
WordC Word2


Thanks

 

[ravishankar]

Hi
Paste the following codes in the macro window ( Alt F11)

Sub hh()
x = Cells(Rows.Count, 1).End(xlUp).Row
y = Cells(Rows.Count, 2).End(xlUp).Row
For a = 1 To x
For b = 1 To y
Cells(a, b + 2) = Cells(a, 1) & "-" & Cells(b, 2)
Next b
Next a
End Sub

run the macro. It will join all combination of words from col A and col B
Ravi

 

[PipSqueakables]

Hi Ravin,

I'm afraid I'm using Mac's new "Numbers". Is there any method without using macros?

Thanks

 

[ravishankar]

Hi
List col A vertically and col b horizontally on row1
B2 = =$A2&"-"&B$1
Drag it down and across. you will have all combinations
Ravi

 

[galileogali]

With the original disposition:

Libro1
	A	B	C	D	E
2	WA	W1	WAW1
3	WB	W2	WBW1
4	WC		WCW1
5	WD		WDW1
6			WAW2
7			WBW2
8			WCW2
9			WDW2
Hoja1

 

[galileogali]

Excuse me for the FormulaLocal in spanish language

Libro1
	A	B	C	D	E
2	WA	W1	WAW1
3	WB	W2	WBW1
4	WC		WCW1
5	WD		WDW1
6			WAW2
7			WBW2
8			WCW2
9			WDW2
Hoja1