Combine Several Cells into a New Cell Based on Criteria

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

Thank you very much jeffreybrown, that is exactly what I needed to accomplish this. I did have to fix my column A but after that it worked great!