multiple rows with some dups where I need result on one line

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.

00313 ANGIE BURBANK
01577 ANGIE BURBANK
01537 ANGIE HOMA
01719 ANGIE HOMA

Do you want the "ANGIE BURBANK in one cell and the combined numbers in
another cell, or do you want it all in one cell? HTH Otto
"VAN GOGH" <VANGOGH@discussions.microsoft.com> wrote in message
news:9E572635-1873-47DB-A31C-FBEC45FF906B@microsoft.com...
>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.
>
> 00313 ANGIE BURBANK
> 01577 ANGIE BURBANK
> 01537 ANGIE HOMA
> 01719 ANGIE HOMA
>

Yes, ANGIE BURBANK IN ONE CELL AND THE COMBINED NUMBERS IN A SEPARATE CELL -
THANKS.

"Otto Moehrbach" wrote:

> Do you want the "ANGIE BURBANK in one cell and the combined numbers in
> another cell, or do you want it all in one cell? HTH Otto
> "VAN GOGH" <VANGOGH@discussions.microsoft.com> wrote in message
> news:9E572635-1873-47DB-A31C-FBEC45FF906B@microsoft.com...
> >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.
> >
> > 00313 ANGIE BURBANK
> > 01577 ANGIE BURBANK
> > 01537 ANGIE HOMA
> > 01719 ANGIE HOMA
> >
>
>
>