Excel

[BAWrites]

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

 

[Gord Dibben]

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

 

[BAWrites]

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

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

 

[BAWrites]

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?