LinkedIn Extract locations and positions for 565 employees

Dear network

Please find a loom video explaining the project:

https://www.loom.com/share/a59d448bc6904e85844d7471b021854a

You have first name, last name, gender and company of certain employees in columns B, C, D, E for certain employees.
1. Please extract the company URL in the column F
2. Please extract the city the person is located according to LinkedIn in column G. If not available, please extract the headquarters of the company

I am looking forward to working with you.

Best regards
Mihailo