Compare cells in column 1 and concatenate values in column 2

Originally Posted by JBeaucaire

I think this question is more properly suited to the Programming forum.

'COLUMNS TO ROWS
Here's a macro for merging columns of data to one row matching for column A, it's exactly the thing you've described..

Columns to Rows - Part 2

There's a sample sheet there where you can test it out.

Thanks .That was wonderful.It might have taken me a day or two to complete that job manually.
That code worked like magic.Thanks again