Combine Multiple Cell Ranges based on adjacent Cell Values

[chaitu585]

I've a range of text with details such as Name, Email ID, Telephone and Address.

I want the all the address lines to be combined into once cell separated by line breaks as given below

I've been using "kutools for excel" combine rows option for these kind of functionality and it is okay for one or two entries. However, here I have hundreds of these address bars and I'd really appreacite if some one could put together a VBA code for this (I've no idea how to write one).

As far as i think, ideal logic to run a loop would be; based on the cell values in column one,

if a cell is filled combine all rows below that (until you can find another filled cell in the column) to the top row. i.e

A1 is filled. Next Filled is A2. so leave row 1.
A2 is filled. Next Filled is A4. So combine rows 2 and 3.
A4 is filled. Next Filled is A6. So combine rows 4 and 5.
A6 is filled. Next filled is A10. So combine rows 6,7,8 and 9.
A10 is filled. Next Filled is A11. so leave row 10
.
.
.
and so on. We can run this loop till a certain row number.

If someone could put this logic into a code, i would be much obliged.

Thanks in Advance.

 

[Macropod]

Duplicate of: https://www.mrexcel.com/forum/excel...s-based-adjacent-cell-values.html#post5011904

Kindly read Mr Excel's policy in Rule 12 against asking questions about the same topic in multiple threads: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html
Thread closed. You may continue the discussion in your other thread.