Loop to two columns and Concatenate values

[LalitPandey87]

@LalitPandey87,

See the above link for the sample data ...

Hi Rick,

I have checked the same on second sample data and it works fine.

[Rick Rothstein]

I have checked the same on second sample data and it works fine.

I tried it again after reading your message and the data still crashed your code. Playing a hunch, I rebooted my computer and now, sure enough, your code works perfectly with that data. My computer must have picked up a "glitch" along the way which had been affecting Excel in some way. Sometimes I just hate computers!

[LalitPandey87]

[Rick Rothstein]

[ivandgreat]

Hi Rick,

Appreciate if you have another solution for this, just to have other option and also learned from different approach.

Thanks again to both of you.