Concatenate Duplicates 2

[Omnicube]

Hi Guys,

I am looking to concatenate duplicates in my worksheet. I looked at the concatenate code samples using the search feature, but I was unable to locate anything that directly applied to my situation. Example below:

Existing Table
Column A Column B
987654321 a
987654321 b
987654321 c
123456789 d
654987321 e
654987321 f
654987321 g

I would like my new table to look like this:

Column A Column B
987654321 a, b, c
123456789 d
654987321 e, f, g

If someone could point me in the right direction, I would appreciate it.

 

[SkipVought]

Well give it a try, why don't you?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]