Concatenate based on text in a different column

Hi,
I am trying to get a complete list of applications per device. I have the device list but it is broken down into seperate lines so i would like some sort of formula (not fussed what type as long as it gets the desired results!) that will look in column A and if the text is the same, to concatenate the info in column b, seperated by a comma. So for the first device (4d713006) i would get 1 cell that would have the list of all 52 applications in it seperated by a formula. This is so i can vlookup the device name from another sheet and pull through all the list of applications.
I hope this makes sense and any help would be appreciated! I have atttached the data :-)

Hi - as hemesh says, this sort of thing is a bit complicated with formulas, although depending what you want to do with the end results you may be able to do it if you ignore the step of concatenating with commas.

You could try getting morefunc and using the mconcat function but it tends to be a simple task in VBA, for example:

Please Login or Register  to view this content.

would transform your example into comma separated lists, press alt+f11 to open the vba editor, click insert->module, then copy the code into the module window and run (F5 whilst the cursor is between the sub and end sub lines)

That is brilliant, works better than i was hoping for as it consolidates the lines for me too! Thank you so much :-)