SQL noob - Car dealership stock orders list : This may have already been asked before, but I couldn't find much. Please redirect me if so.

I work for a big car dealership in Switzerland. We receive dayly a List of cars in our carparks located all around the country. 
This list serves us to find which car our clients are looking for, so that we can propose them an offer.
The list is huge and difficult to work with.
For instance all optional and modelversions are written all in one cell....
So I had the idea to build a database, with a research form and a report in Ms Access so that we just need to load this list in an excel sheet, run a formatting macro in order to have a proper list to work with, then feed it to the database through table connection. This will definitely save us a lot of time 
So, at the end of the formatting macro my list look kinda like this:[formatted car list][1]


Since the same Optionals on different cars have different prices I need to have my Data to look like this:[target table format][2], so that in my report I can do  a table join query and have a list of the car's optionals with their prices.
Is there a way to do a "Table Normalisation" in MS Access?
Ty all for the answers in advance!


  [1]: https://i.stack.imgur.com/jWVBF.jpg
  [2]: https://i.stack.imgur.com/kDs8i.jpg