Are you able to do research and clean and consolidate data in excel spreadsheets?

I have a large list of venture capital firms and angel investors in the US, I need the data on the sheets consolidated (merging two similar lines into one), duplicates removed, and the venture capital firms need to be vetted for investment fit by three criteria to see if they are a good fit for our company.