Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BAWrites - 31 Jul 2008 18:05 GMT

I have a spreadsheet comprised of entries like this :

726016004084      ALV BAG DANDELION     United Natural Foods
Inc.
726016004084      ALV BAG DANDELION     Select Nutrition
Dist.
726016004084      ALV BAG DANDELION
Threshold
726016004190      ALV BAG ECH-GOLD-SEL      United Natural Foods
Inc.
726016004213      ALV BAG ELDERBERRY
Threshold
726016004213      ALV BAG ELDERBERRY      Select Nutrition
Dist.

What I want to do is reduce the list so

726016004084      ALV BAG DANDELION     United Natural Foods
Inc., Select Nutrition Dist., Threshold
726016004190      ALV BAG ECH-GOLD-SEL      United Natural Foods
Inc.
726016004213      ALV BAG ELDERBERRY      Threshold, Select
Nutrition Dist.

Is there a means by which I can accomplish this in Excel without going
to an outside text editor? Perhaps a VB function or something? Tips
pointers or better yet solutions are appreciated!

Regards

Ben

Reply to this Message

Gord Dibben - 31 Jul 2008 19:31 GMT

Assuming the news reader line-wrapped and you have just 6 rows with some
duplicates.

Select column A then Data>Filter>Advanced Filter

Unique records only and copy to another place.

For more on this see Debra Dalgleish's site

http://www.contextures.on.ca/xladvfilter01.html#FilterUR

Gord Dibben MS Excel MVP

>I have a spreadsheet comprised of entries like this :
>
[quoted text clipped - 27 lines]
>
>Ben

Reply to this Message

BAWrites - 31 Jul 2008 20:07 GMT

I'll give it a shot - thanks!!!

> Assuming the news reader line-wrapped and you have just 6 rows with some
> duplicates.
[quoted text clipped - 40 lines]
>
> >Ben

Reply to this Message

BAWrites - 31 Jul 2008 20:38 GMT

No dice, doesn't really explain how to bring the data from three
consecutive rows (in the same column) and concatenate, separated by
commas.

Any other suggestions?

> I'll give it a shot - thanks!!!
>
[quoted text clipped - 42 lines]
>
> > >Ben

Reply to this Message