Hello!

I"m pretty confused. I'm having an issue with finding a way to merge data within cells. The function I'm trying to replicate would be the =join function in Google Sheet. I believe it's just a simpler =CONCATENATE. If possible I'd to come up with some "IF" formula I could scale. I'd like to use "IF" to see if the root/sub domains/email contacts (column B,C,D) match and if they do, combine all the simlar "source URLs" (Column A) in one text string in a different cell. I attached a picture below


Pic.jpg



Thanks in advanced,
Just another case of the mondays,