Combine 2 series' of text into 1 column using concatenate

[BRennerDC]

It seems like the solution to my problem should be very easy, but I am not sure of the terms which makes it difficult to search for answers.
I am using Excel 2003/WinXP.
I have 2 columns of data (all text, no numbers).
Col. A has a range of 20 unique values.
Col. B has a separate range of 3 unique values.
I want to create a new column that combines the text from column A and B, but in this way:

Col. A......Col. B......Col. C
a1...........b1...........a1&" - "&b1
a2...........b2...........a1&" - "&b2
a3...........b3...........a1&" - "&b3
a4....................... ..a2&" - "&b1
a5..........................a2&" - "&b2
..............................a2&" - "&b3
..............................a3&" - "&b1
..............................a3&" - "&b2
..............................a3&" - "&b3

Where Col. A is a list of countries and Col. B is organizational categories such as Cost, Participants, Lectures, etc.
Basically the result should match each entry in column A with every entry in column b to create a new series. Its ok if the solution involves macros or another 'set-up' column. My eventual purpose is to create labels from col. C (this all started while trying to get mail merge to do it from Word) and over time, the only new data will be additions to Col. A. Column B is a fixed list that never changes.
Thanks very much for any help you can provide. Let me know if I've left anything too vague.

 

[Andrew Poulsom]

Try:

=INDEX(A$1:A$5,INT((ROW(A1)-ROW(A$1))/ROWS(B$1:B$3))+1)&" - "&INDEX(B$1:B$3,MOD(ROW(A1)-1,ROWS(B$1:B$3))+1)

 

[BRennerDC]

That worked! Thank you so much. I've never used the INDEX feature - it seems like it will come in very handy in the future.