Scrape contact information from web pages to create contact list

To go to https://partneredge.sap.com/content/partnerfinder/search.html#/ select country United Kingdom and extract contact details into a spreadsheet. This means going into each partner page such as: https://partneredge.sap.com/content/partnerfinder/search.html#/partner/details/0000034720 to find the information that is to be copied into the relevant column in the spreadsheet.

In column 1 are highlighted partners to be EXCLUDED.

I have already copied the partner list into column two but this should only contain the company name which means that the other content needs to be moved across to the relevant column. I have done this exercise once already so know how much time it roughly takes but lost the file due to a laptop problem. There are 157 partners of which 20 are excluded leaving 137 to populate.

Any questions please contact me.