Hi guys, I think I've got quite a tricky one here!
I've got a list of information which is like this
Mr A Conversation 1
Mr A Conversation 2
Mr A Conversation 3
Mr B Conversation 1
Mr B Conversation 2
Mr C Conversation 3
Mr C Conversation 4
Mr C Conversation 1
Mr C Conversation 2
What I want to be able to do is have all the Conversations had with Mr A to turn up in the same cell (As they would do if I did it manually with an "&") - any ideas? and the same for Mr B etc... there are varying numbers of conversations with each person.
Help very gratefully received to save me a lot of work!
I've got a list of information which is like this
Mr A Conversation 1
Mr A Conversation 2
Mr A Conversation 3
Mr B Conversation 1
Mr B Conversation 2
Mr C Conversation 3
Mr C Conversation 4
Mr C Conversation 1
Mr C Conversation 2
What I want to be able to do is have all the Conversations had with Mr A to turn up in the same cell (As they would do if I did it manually with an "&") - any ideas? and the same for Mr B etc... there are varying numbers of conversations with each person.
Help very gratefully received to save me a lot of work!