Hi
This is tricky to explain so I will show the output I want below, basically if the same unique value is in one column I would like to concatenate values from those unique value in the existing column to create one row. Easier to demonstrate. I wonder would anyone know some macro code to achieve this..


Head1 Head2
123 joe
154 steve
123 tom
129 kate

to give


head1 head2
123 joe,tom
154 steve
129 kate

Thank you for any help