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.

Please Login or Register  to view this content.