Hi Ely,
Actually I'd use the macro by rearranging the columns as it
does exactly what you asked for.
.http://www.mvps.org/dmcritchie/excel/fillhand.htm#mouse
you could use the macro as is, if not comfortable changing the macro
If you have not installed/used macros before see
http://www.mvps.org/dmcritchie/excel/getstarted.htm

For information on Pivot tables see
http://www.contextures.com/tiptech.html

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ely" wrote in message ...
What is Pivot Tablej ? How do I get it/use it...

"David McRitchie" wrote:

Hi Ely,
try using a Pivot Tablej

or a macro solution
http://www.mvps.org/dmcritchie/excel...tm#joining.htm
of course this is just using the second sheet as input in creating another sheet
if sheet1 has to be used for input then neither of these solutions would work
for you.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ely" wrote in message ...
Hey All!

I'm trying to pull country prefixes for matching countries from the second
sheet that has recurring countries with respective prefix to the first sheet
that is not recurring, prefix for same country in one cell separated by comma.

Please see attached link for a visual description.

Will appreciate your input.

Link: http://www.excelforum.com/attachment...0&d=1135879308