I have 2 sets of data, which has:
Sheet 1 (Business Details) has 21 business details, but no email addresses (in the Email column).
Sheet 2 (Website-Emails) has 8 websites from Sheet 1, along with an email address for each, yet as not every website from Sheet 1 has an email address available, Sheet 2 misses those out.
What I want is to automatically combine all 8 email addresses from Sheet 2 into Sheet 1, so the email address column is completed where applicable. Obviously, not all will be filled, as there's 8 email addresses and 21 business rows. So 13 will remain blank.
The problem is, I can't just copy-paste as they won't align - the website's correct email address won't go into the correct row.
Apologies if this isn't clear. I'll try my best to explain if there are any queries.
While this spreadsheet is only a few rows deep, I'm working with much bigger numbers/rows so it needs to be a method that I can easily use.
business-data.xlsx
Bookmarks