software

I have the following cells A1:A4 and B1:B4 where I need the duplicates in
column B one time and the corresponding results from column A combined in one
cell only once.

I'm looking for this result: ANGIE BURBANK O0313, 01577, etc. - Thanks a
bunch.

00313ANGIE BURBANK
01577ANGIE BURBANK
01537ANGIE HOMA
01719ANGIE HOMADo you want the quot;ANGIE BURBANK in one cell and the combined numbers in
another cell, or do you want it all in one cell? HTH Otto
quot;VAN GOGHquot; gt; wrote in message
...
gt;I have the following cells A1:A4 and B1:B4 where I need the duplicates in
gt; column B one time and the corresponding results from column A combined in
gt; one
gt; cell only once.
gt;
gt; I'm looking for this result: ANGIE BURBANK O0313, 01577, etc. - Thanks
gt; a
gt; bunch.
gt;
gt; 00313 ANGIE BURBANK
gt; 01577 ANGIE BURBANK
gt; 01537 ANGIE HOMA
gt; 01719 ANGIE HOMA
gt;
Yes, ANGIE BURBANK IN ONE CELL AND THE COMBINED NUMBERS IN A SEPARATE CELL -
THANKS.

quot;Otto Moehrbachquot; wrote:

gt; Do you want the quot;ANGIE BURBANK in one cell and the combined numbers in
gt; another cell, or do you want it all in one cell? HTH Otto
gt; quot;VAN GOGHquot; gt; wrote in message
gt; ...
gt; gt;I have the following cells A1:A4 and B1:B4 where I need the duplicates in
gt; gt; column B one time and the corresponding results from column A combined in
gt; gt; one
gt; gt; cell only once.
gt; gt;
gt; gt; I'm looking for this result: ANGIE BURBANK O0313, 01577, etc. - Thanks
gt; gt; a
gt; gt; bunch.
gt; gt;
gt; gt; 00313 ANGIE BURBANK
gt; gt; 01577 ANGIE BURBANK
gt; gt; 01537 ANGIE HOMA
gt; gt; 01719 ANGIE HOMA
gt; gt;
gt;
gt;
gt;