Is there a formula I can use to do this without writing my own function...?
I have a name in column A, and a version in column B. I want a formula to concatonate into column C all of the versions per name.
e.g.
Name Version
me123456 1.2
me123456 2.2
me654321 3.2
me123456 4.2
me654321 5.2
me654321 6.2
so column C for the above would then be (I'm not worried about the duplicates, I can sort that separately):
1.2, 2.2, 4.2
1.2, 2.2, 4.2
3.2, 5.2, 6.2
1.2, 2.2, 4.2
3.2, 5.2, 6.2
3.2, 5.2, 6.2
Thanks
Bookmarks