Hi Azumi,

Thanks for the formula, its great.
I understand that as per your statement its not possible in one cell, but, my concern is to get in one cell. IF using the given formula and dragging to down cannot make my work. There were many rows like row B to its down. I have given just one row example. Could you please help any alternate. I tried dragging to right instead of down if it happens, then thought i can concatenate those cells into one as per the output, but no luck in dragging to right.