Combining lists

[sobel]

I was told Excel can do this, but I'm not very familiar with the program.. Example:

First Names: John, Ryan, Michael
Last Names: Smith, Williams, Jones

I need to create a final list that will look like

John.Smith
John.Williams
John.Jones
Ryan.Smith
Ryan.Williams
Ryan.Jones
Michael.Smith

etc

Any help in the right direction would be much appreciatd. I've googled but have only used Excel for very simple tasks and formulas. Thank you so much.

[BenMiller]

Are the names currently all housed in one cell? Can you have the first and last names running down a column? That would be a lot easier to write a formula for, without having to resort to VBA/macros.

For a quick fix, you can use Text-To-Columns with a comma as your delimiter, then copy and paste special>transpose the data to store it vertically.

Can you do that?

[sobel]

Thank you for the reply.

The first and last are in columns of their own. The First Names are A1:A596, and the Last Names are B1:B410.

I will google more about Text-To-Columns and the Transpose to see if I can find a solution. Thank you.

[BenMiller]

Try in column C - =INDEX(A:A,INT((ROW(A1)-1)/411)+1)&"."&INDEX(B:B,MOD(ROW(A1)-1,411)+1)

You'll have to drag it down 245,367 rows to get all the possible combinations.

[sobel]

That was perfect.

If you're ever in Charlotte and need a beer, I'll buy you a case.

[BenMiller]

No problem Glad I could help ... Appreciate the feedback!

And we're about 600 miles apart ... 500 is my max for a beer