Master Chemical Data Consolidation

I have several Google Sheets that each hold pieces of our chemical inventory—properties, safety notes, batch IDs, and other scattered details. I need everything merged into one clean, searchable master record.

Your task is to pull the data from every source sheet I provide, remove duplicates, align the column headings, and return a unified file ready for day-to-day use. I’m open to keeping the final record in Google Sheets or exporting to Excel if that makes cleaning or future reporting easier; let me know what you recommend. Data integrity is critical, so consistent CAS numbers, standardized units, and intact safety information must be maintained throughout the merge.

Deliverables:
• A consolidated master sheet containing all original fields plus any new indexing you create for easier look-up.
• A brief change log explaining how duplicates or conflicts were resolved.
• Simple written instructions (or comments inside the sheet) so my team can keep the record up to date going forward.

I’ll share view-only links first, then grant edit access once we agree on a workflow. If you’ve wrangled large scientific datasets before—especially with Google Sheets, Excel, or scripts in Apps Script/Python—your experience will be a great fit.