merging multiple cell in to one cell

[santoshbhagade]

Hi,

I need to merge multiple cell in to one cell, i know that it can be possible through & formula and CONCATENATE formula. But my challenge is i want the result in one cell with each is below each one. I have attached a sample file, please check and help me to be awesome in excel

Thanks in advance.

 

[NARAYANK991]

Hi ,

I am not able to understand this :

But my challenge is i want the result in one cell with each is below each one.

Can you explain with more than one example ?

Narayan

 

[santoshbhagade]

Hi Narayan,

thanks to look into it.

i want the multiple cells into one cell with line break. may be i am not able to explain it well, you can look into the attached file in initial thread so you can get an idea on this.
Thanks.

 

[santoshbhagade]

Hi Narayan, Thanks for your concern, However google helped me to find out solution on this, please refer to the attached file.

thanks again.