I'm not sure which formula or macro needs to be used for my query. I have a spreadsheet that is a report of all employees who have full control access to a SharePoint site. What I want to do is send a targeted email to each site owner and in it have a list of sites/URLs they are an owner for. The list has thousands of rows and the columns are:

Site Name
Site URL
Owner - each row in this column has employee logon IDs separated by a comma. I think this would first need to be split into one cell per user

I want to extract a list of each employee logon ID showing the Site Names and URLs they are an owner for, without putting in each one as a match as there are 10,000 sites all with multiple owners.

Any help is appreciated!