Quote Originally Posted by JBeaucaire View Post
Hi Praney. Welcome to the forum.

This is doable, but will most likely involve adding some VBA to your workbook. You OK with us using macros to solve this? This isn't the programming forum, so I thought I should ask before spending any time on it.

If so, click GO ADVANCED and use the paperclip icon to post up your workbook. Make sure the sample workbook has a few sample "results" so we can clearly see your goal.

Also, is this a one-off need? Or do you need something that is operating all the time in real-time to keep these concatenated fields filled in?
HI JBeaucaire,

Thanks a lot for the suggestion I'll do it and its a one-off need.

Regards,
Praney