Convert multiple values to one string

[MarionT]

Hello - not quite sure if that title says anything helpful, but here goes a better explanation:


Source Data will be: Article#,Publisher,Text1,Text2,Text3

1,mary,xxx,xxx,xxx

2,John,xxx,xxx,xxx

3,Susan,xxx,xxx,xxx

4,John,xxx,xxxx,xxx


There will be approximately 100 articles; I'm not sure how many publishers

Each publisher may have more than one article


At the end of the day, I'd like to have an additional column that is a list of the articles for that publisher (it's ok for each publisher to appear multiple times; we'll just extract unique)


Mary: 1

John: 2,4

Susan: 3

John: 2,4


We've figured out a way using pivot, and I came up with another clumsy method using lookups, but, is there an easier way?


Thank you !


Marion

 

[Hui]

Marion

Have a read of Jive's post towards the bottom of

http://chandoo.org/wp/2008/05/28/how-to-add-a-range-of-cells-in-excel-concat/

That should point you in the right direction

 

[MarionT]

Not sure if that will work or not..... but thanks.


This is for my daughter, who's using a mac. so she won't able to try it with the vba code