Excel

  • Thread starter Thread starter BAWrites
  • Start date Start date
B

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
 
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?
 
Back
Top