Hello all,

I am hoping someone could help me with my current data. I will try to explain this as best as I can. I am working in Excel 2007.

I have two columns, A and B, with data where the first column contains a cell with one name and the second column contains several cells with a description of the name. The description matches to the name and all the blank cells under the name. For example:

Name 1 Descrption 1,
Descrption 2
Name 2 Descrption 1,
Descrption 2,
Descrption 3

I have over 1000 names that also have the description cells in the second column but divided into several cells ranging from 1 cell to 4 cells. I need the description cells text to be merged into one cell aligned with the name in column C with a space added between each description. For example:

Name 1 Descrption 1, Descrption 1, Description 2
Descrption 2
Name 2 Descrption 1, Descrption 1, Descrption 2, Descrption 3
Descrption 2,
Descrption 3

Essentially I need a macro that looks at column A's "Name" and all the blanks under that name, then copies all the text parallel to those cells in column B to column C aligned with the "Name". I need the macro to do this for every name available. If anyone could help me accomplish this, it would be extremely appreciated.

Thank you