Filter out key words in a 1900 row excel sheet

Hi,

I am looking for a skilled data entry person to fill out this database preferably with a script/code.

I have filled out the first 30 results to showcase the variation of results. (which makes it not easy to script)

The information in Column B needs to be extracted and split in the correct columns C,D,E,F.

To help you with this task, I have also attached a keyword list so you can note down the correct details in the correct columns.

The project needs to be started as soon as possible and finished on 20th April.

Kind regards,
Philip