Combine cells in column A if the cells blank in between in columnB

[coronakyk]

Hi,

I have data per example below. Can the macro turn the data under example to outcome? If yes, what is the coding?

Example:
Title A Title B Title C
AAAA 1234 Jan'14
BBBB- 2345 Feb'14
bbbb
CCCC- 4363 Jan'14
cccc
vvvv
DDDD 7456 Jan'14


Outcome:
Title A Title B Title C
AAAA 1234 Jan'14
BBBB-bbbb 2345 Feb'14
CCCC-ccccvvvv 4363 Jan'14
DDDD 7456 Jan'14

Thanks.

[JOHN H. DAVIS]

Welcome to the Forum.

Maybe:

Please Login or Register  to view this content.

[coronakyk]

Hi John,

Thanks for the input. What if the title A is in column 3?

[JOHN H. DAVIS]

Would Title B be in column 4 then?

[coronakyk]

Yes. Title A in column 3, Title B in column 4, Title C in column 5...

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[coronakyk]

Hi John,

This code works pretty well if Title B has data, what if Title B does not have Data and like sample attached?
Thanks.

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.