Simple webscraping project from single website -- 2

Job ID: 35490706

Budget: $10 – $30 USD

I want to extract drug data from https://bnf.nice.org.uk/drugs/ ( needs to be accessed via vpn as only accessible from UK) for each drug and the same from https://bnfc.nice.org.uk/ to create drug database for children.Here the column labels and numbers may be same or different- not sure
Need a UI path or Python bot to extract data from each drug and populate the appropriate column. Not all drugs have information in each column . If no information ,column MUST be BLANK.

The previous output file is atttached. However a few fields have wrong data as the bot did not empty the memory after writing to the cell. The OUTPUT must look like the attached file but with accurate data