Posted by Kevin James on May 04, 2001 11:01 AM
Well, I did a complete search on the message board looking for "duplicate", "group", "match" and other words. I didn't quite see what I'm looking for, even though I am sure I saw a posting within the last two weeks that asked a similar question.
Copy the following into a CSV file and then open it into Excel:
What I want is a formula (not VBA) that will render:
Column A ColumnB
I am not tracking food, this is just an oversimplified example. In each instance the ProductLine will have been sorted so that all "fruits" and "nuts" are within a contiguous range of rows. I don't care that Item is sorted, it can be concat'd in sequential order.