Excel 2007 : deleting duplicates but keeping row values

[moldoverb]

I want to summarize some data across rows in a large spreadsheet. There is a duplicate value, and I'd like to basically consolidate all the data in rows that match that value:

50253 5 A
50253 5 C
50253 5 F
50253 5 G
50253 5 H


Should consolidate down to a single row:

50253 5 A C F G H

Any ideas?

[JBeaucaire]

Hi Moldoverb. I have a Consolidate macro for this, but it is critical to understanding the columns before it can be tweaked for you.

Is that a 3-column example dataset? Do columns A and B both have to match to be considered "the same"? Or just column A?
Can the data be sorted prior to consolidation to insure all like items are adjacent, like in your example?

Any chance you can simply post a usable sample set of data to test on? Click GO ADVANCED and use the paperclip icon to post up your workbook.

[JBeaucaire]

Here's the basic macro for comparing matches in columns A & B and merging all the column C data into row format.

Please Login or Register  to view this content.

[moldoverb]

Thanks, well it's a data set where I am looking at a number of samples (A,C,E,F,G,H) trying to find out what is in common (second column). The third column is an occurrence count and actually not important since I deleted all entries <4 samples in common. File is attached.

[moldoverb]

Still looking for an answer to this question.

[JBeaucaire]

Perhaps a shorter sample of data where you show us both the BEFORE and AFTER. I can't see anything that would would "join" based on that data, so a visual example might make it clear.

[moldoverb]

I just figure out how to do this with a pivot table. Thanks for the advice, though!