Data Entry in Microsoft Excel

Hello! We'd like your help in getting 607 contacts in an Excel file. The information is retrieved from a website (we'll give you the login details later). The addresses can be accessed by just a few clicks (click name, go back, click new name, go back ?). See screenshot 1 how the addresses appear. See screenshot 2 how we need it in Excel format. We need NAME, CITY, PHONE, EMAIL, WEBSITE and CONTACT in an Excel file. Important: sometimes a few information are missing on the website. In this case, leave it blank. It's important it always remains 1 row. For example, all "Email" addresses are in 1 row (in our example E5)