Merge multiple cell into one

[Pinang]

Hi,

I want to merge my result from multiple cell using CONCATENATE formula. Can anyone help me to create formula.

Refer attached file for more details.

 

[Asheesh]

Hi Pinang...

Check if this helps....actually concat doesnt work on a range...so had to use helper columns...check the ones highlighted in blue..

 

[Lymm]

Have you considered using a Pivot table? It may give you what you need

 

[John Jairo V]

Hi @Pinang (@Asheesh and @Lymm)

I have written some code for you. This code works too if the PS Number is duplicated, writing only one. Click in orange arrow (Worksheet "Res"). Blessings!

 

[Pinang]

Thanks a lot everyone

 

[prasaddn]

Hi Pinang...

Check if this helps....actually concat doesnt work on a range...so had to use helper columns...check the ones highlighted in blue..

Hi,

Very nice formula Asheesh!

Just replace Trim with substitute function to get the commas as well.
example:
=IF($E10="","",SUBSTITUTE("("&G10&" PS No "&I10&", "&J10&", "&K10&", "&L10&", "&M10&", "&N10&", "&O10&", "&P10&")",", , ",""))

Regards
Prasads DN

 

[Asheesh]

Hi Prasad, nice catch...just dint notice that we needed commas as well..