Good Afternoon,
I'm trying to figure out how to take a set of values in a table and concatenate by the name in Column A.
Below is an example of what I'm talking about.. Should be faily easy, right? I'm willing to use VBA as well.
BEFORE:
AFTER:Code:jdoe 11 jdoe 12 jdoe 13 jdoe 17 asmith 18 asmith 21 asmith 23 ljones 10 ljones 11 ljones 14
Code:jdoe 11, 12, 13, 17 asmith 18, 21, 23 ljones 10, 11, 14