I have some data in two columns like this:
001 blue
001 blue
001 red
001 green
002 blue
003 green
003 green
004 red
004 green

What I need to do is show the data on another sheet like this:
001 blue, red, green
002 blue
003 green
004 red, green

So I need to concatenate the unique items in the list for each id in the
first column. I would like to do this via a macro because I will have to do
it each month on a different workbook. Any help is appreciated!