Excel Data (inventory) base cleanse and manipulation

Job ID: 32484685

Budget: $15 – $25 AUD

I have a large Excel sheet taken from a Micorsoft Access Database. I need to clean up the data set, remove double ups of codes, ensure all codes have mandatory fields filled and assign new inventory part id based on manufacturer and model, leaving room for growth