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 :-)
Bookmarks