Inventory Excel Data Cleanup

I have an inventory spreadsheet that has become cluttered over time and now needs a thorough clean-up. My priority is to organise the file so every item record is complete and easy to read. The biggest headache is duplicate or missing item details...