Combine rows based on blank columns

Hi,

I have been browsing this forum for quite a while and have found it extremely useful but have never had the need to post a question until now. Being that my VBA skills are still in development I was wondering if anyone could assist me a problem I am encountering.

Column A is populated with either names or fragments of sentences. In column B, all the names have a corresponding number associated with them and the sentences have a blank cell. The sentences below the names are information about the names. What I need to do is combine the sentences and output that result into Column C of the name above it.

I have tried to loop based off of the blank cells but have been unsuccessful in my attempts. I have attached a sample sheet showing the problem. Thank you in advance for any help you can give me.

-Steve

Not quite sure what you are trying to acheive but the following macro will build split sentences into single ones.

Sub Test()
For N = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
    If Cells(N, 2) = "" And Cells(N - 1, 2) = "" Then
        Cells(N - 1, 1) = Cells(N - 1, 1) & " " & Cells(N, 1)
        Rows(N).Delete
    End If
Next N
End Sub