VBA Code for Combing Lists

[Macro628]

Hello,

I'm looking for a method to combine values from one list and have it match to another list then create two new columns from that data. I enclosed an example of this problem within this post..

Thank You for your time..

[mikerickson]

Put this formula in one cell =INDEX(A:A,1+INT((ROW(A2)-2)/COUNTA(B:B))+1,1)&""
And this in the cell to its right =INDEX(B:B,MOD(ROW(A1)-1,COUNTA(B:B)-1)+2,1)&""


Then drag down.

[Macro628]

Thanks that did the trick!