I need an efficient way to rip a table of names from publishersmarketplace.com into an organized spreadsheet for Google Contacts. My goal is to send an email to over 2000 people using Mail Chimp. In order for Mail Chimp to smoothly take all those names, I have to organize the list of names to look like this. The picture shows the website on the left, and on the right is how Mail Chimp is able to import it smoothly with no errors (I did this by manual copypasta which drove me nuts. There's got to be a way to automate this!). So basically.. how do I make the web table of names look like the organized spreadsheet without resorting to manual copypasta labor? I'm told it is impossible and I must copy and paste each individual name from the website - to a spreadsheet. No way, there's got to be a way! Here is a list of methods I have tried:

=ImportHtml(URL, “table”, num) yielded me random results particularly when I toy with different number values (URL, "table", 1 or 2 or 3 or 4 etc). It imports random text from the left side of the website that holds hyperlinks. I gave up after punching in so many values and it led nowhere.

I toyed with the data toolbar for Chrome following the tutorial. It only imported the first person of each and every page. Or if I were to highlight the third person on the list, then it would import only the third person of each and every page. I was so close with this one...

The most secure method I used in Excel was the Data/Get External Data/From Web tool. It perfectly imported the list of names, but then I have to organize the spreadsheet so that Google Contacts/Mail Chimp can smoothly import it. Here is a picture that shows what it looks like when I used the Get External Data tool. How can I filter the spreadsheet to contain only the first name, last name, and email in a vertical list?

The website requires paid registration so if you have any more questions, I'll screen capture more pics. Thanks so much to anyone who can solve this!