Problem in combining records having same address

Raj

Have you looked at the solutions that have been provided for your other, very similar, posts. And have you tried to adapt those solutions for this slightly different output format? If so, how about you show your code, and show where it was not meeting your requirements.

Here's one, and a quick search shows that you have other solutions.

rylo

Raj

On your sheet data, you have some data in the range A2:H22, then a huge gap, some odd items in column I, some more gaps, then some more data in A4315:H4429.

How much of this is valid data, and how much is a hangover from previous runs that hasn't been properly cleared? If it is valid, then you will have to do a sort on the data to get rid of the blank rows, and do a clean up of the missing data before you can progress. If you have partial data, and you want to include it, then fill the missing items with something like "FILLER" so when they get extracted, you will know that these are incomplete items that have to be reviewed.

And if the previous posts have solved the questions raised in them, can you please revisit the posts, and marked them as SOLVED.

rylo

Hi Rylo

Many Thanks for your reply. Code is working perfectly fine and my problem is solved now. Thank u so much for your help.

Cheers
Raj