Advanced tools to find and remove duplicates across one or two tables, highlight unique values, trim extra spaces, and fix "fuzzy" typos or near-matches.

Easily transpose ranges, unpivot cross-tab tables into flat lists, and swap cells, rows, or columns.

Includes a Merge Tables Wizard (vlookup-style matching without formulas), tools to combine multiple worksheets into one based on headers, and features to consolidate data from different workbooks.

Quickly change text case, split names into separate columns (first, middle, last), extract substrings, and use Regex (regular expressions) for advanced searching.