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.
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.