Formula HELP!!

[Strong_Warning]

Hi All

Ive got one that has me stumped. I appreciate any help anyone can give me on this one!!

Sorry I dont know how to post examples in here properly but here goes


ColumnA ColumnB
ab67 App-Infran InfranView 4.27 R1.0-User
ab67 App-Mindjet MindManager 9.1.157 R1.0-Comp
ab67 App-Pitney Bowes MapInfo Pro 10.5 R1.0-Comp
ab67 App-Space-Time Research SuperTABLE 6.5.1 R1.0-User

I have a list of pc applications for each user ID. Each application & user ID is on a different row.

What I need is to concatenate all the apps for each user with comma's separating them

so if column A = ab67 then I want to return a result of :
App-Infran InfranView 4.27 R1.0-User,App-Mindjet MindManager 9.1.157 R1.0-Comp,App-Pitney Bowes MapInfo Pro 10.5 R1.0-Comp,App-Space-Time Research SuperTABLE 6.5.1 R1.0-User

Forgive me if concatenate is the wrong function here but if anyone can help me on this one I will really appreciate it!!

Thanks heaps

 

[Ruddles]

Would a VBA solution be acceptable?

Would you know what to do with a VBA module if it was posted here?

These records all have the same userid. Would you be able to post a larger sample containing more different ids?

Can you guarantee that the file is grouped by userid?

 

[Strong_Warning]

All good thanks Ruddles I ended up using a =REPT formula & that did the trick

Cheers

 

[Ruddles]

Could you spare a moment to post that here? It might help someone else seeking a similar solution some time in the future, and they search the forum.

MrExcel features quite highly in Google search results.

 

[Strong_Warning]

Sorry I was a little too keen to get out on Friday, it was the below formula not the =rept

IF(A2=A3,CONCATENATE(H3,",",L2),H3)


This returns a result on each line. I wanted only the line with the entire list concatenated so I used IF(A2<>A9,L9,"")