Alex T.

yes

But how will I merge the interests together from 2 different rows and not 2 different columns?

I have 8 lists of prospects. Each list represents a feature a prospect is interested in. A prospect could be on 3 or 4 lists at a time. I want to be able to merge those so 1 prospects appears once with his 3 or 4 interests in one box. How could I do this?

That's a good one, thanks for sharing

We usually get it from the website of the prospect and make sure to get the HQ one. Or we use google search and the business description on the right hand side returns the main phone number.