How to consolidate results of different rows to a single cell

[ahamed982]

I have set of data in rows as follow;


Row 1 - 123

Row 2 - 4586

Row 3 - 8921

Row 4 - 125486

Row 5 - D145


How can I construct a formula to bringing all this five rows into a single cell which results an answer as follow;


123,4586,8921,125486,D145


The conventional method is to link 1 by 1 row with the help of '&' and ","


But I'm looking for a one end formula that can serve this purpose.


I would appreciate if anyone can help me on this


Thank you in advance

 

[Faseeh]

Hi Ahmed,


Welcome to the forums!!


This post of Chandoo will resolve your problem:


http://chandoo.org/wp/2008/05/28/how-to-add-a-range-of-cells-in-excel-concat/


Regards,

Faseeh

 

[ahamed982]

Hi Faseeh


Thank you for sharing the post.

 

[Faseeh]

You are welcome!


Faseeh