Ultimate Suite Features:

Merge and Consolidate
- Merge two tables and add missing columns and rows.
- Match and merge two tables based on key columns.
- Summarize data from several ranges into one sheet.
- Copy data from the selected ranges to one worksheet.
- Turn workbooks to worksheets and place the resulting sheets to one file.
- Combine identically named worksheets into one.
- Copy the selected worksheets to one workbook.
- Merge the selected rows or columns.
- Join several cells keeping all data.

Dedupe and Compare
- Compare two tables for duplicate and unique values.
- Find unique values in one table.
- Find and delete, select, color, copy or move duplicates in one Excel table.
- Find and process duplicates and their 1st occurrences.

Combine and Split
- Combine duplicate rows and paste unique data to one line.
- Split a big table into separate lists by values in the selected column.
- Split multi-part names into several columns.

Transform and Reshape
- Convert summary table to a flat list.
- Transform your table into label cards.
- Swap two ranges in your sheet or workbook.
- Flip the selected range vertically or horizontally.
- Convert rows to columns and vice versa.

Randomize and Fill
- Generate unique random numbers.
- Get random dates and Booleans.
- Save custom lists with values to get random data from them.
- Generate strong passwords, codes, and testing data.
- Shuffle cells in rows, columns, or in the selected range.
- Select certain number or percentage of data at random.
- Fill empty cells with value above or below.

Find and Check
- Find partial duplicates, typos and misspelled words.
- Search and replace data in values, formulas, hyperlinks, and comments.
- Search and export or select the found values.
- Find and fix broken references to other workbooks.

Trim and Clean
- Trim extra leading, trailing, in-between spaces, and  .
- Add text to the selected cells by position.
- Split a column with text to several columns.
- Change text case in your Excel table.
- Convert numbers stored as text to numbers.
- Extract text.
- Remove characters by position.
- Clear formatting in your table.
- Remove non-printing, numeric, text characters, symbols and punctuation marks.
- Convert line break and other characters to any custom symbol.

Select and Calculate
- Count and sum cells based on their color.
- Select certain color to count or sum cells.
- Apply Average/Max/Min functions to the colored data.
- Select cells by type.
- Select cells by value.
- Keep the same selection when switching between sheets.
- Select any value in your list to filter your table.
- Search cells based on their value or color.
- Apply basic calculations to the selected cells.

Quick Utilities
- Delete empty rows, columns and sheets.
- See all open workbooks and sheets on one pane.
- Instantly move columns in your table.
- Insert a watermark in Excel
- Add a Table of Contents
- Get cell or range address to Clipboard.
- Convert formulas to relative or absolute.
- Insert a picture comment in 2 clicks.
- Change a comment shape.
- Manage comments.
- Replace formulas with values.
Release Notes

Supported Windows versions:
- Windows 10
- Windows 8.1
- Windows 8
- Windows 7
- 32-bit and 64-bit

Supported Excel versions:
- Excel 2019
- Excel 2016
- Excel 2013
- Excel 2010
- Excel 2007
- 32-bit and 64-bit
- Desktop Excel included in Office 365 / Office 365 ProPlus