Merge lists even with typos and inconsistent names. Tune the similarity threshold, use a transform table, and audit results ...

Get & Transform in Excel can help you search for data sources, make connections, and shape that data in ways you deem fit. For instance, you can remove a column, change a data type, or merge tables.