merge sub-suplicates
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:
fruit,apples
fruit,oranges
fruit,bananas
nuts,walnut
nuts,pecan
nuts,peanut
nuts,cashew
What I want is a formula (not VBA) that will render:
Column A ColumnB
fruit apples,oranges,bananas
nuts walnut,pecan,penanut,cashew
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.
Kevin
Posted by Aladin Akyurek on May 04, 2001 11:14 AM
Posted by Kevin James on May 04, 2001 11:38 AM
Re: merge sub-duplicates
Hi Aladin,
That was indeed the message I was thinking of, but the results are not what I need. I only tried suggestion #2 but it seemed like the most likely candidate to give the results.
I was thinking that through some combination of the use of INDEX, MATCH, and OFFSET I might create the results I want. For some reason, I find the MS-Help on this functions difficult to follow and even harder to extrapolate how I would use them for my particular need.
Much thanks for the posting though!!!
Kevin
