Simplify

Description

Simplify is a Microsoft Excel add-in that performs a variety of data manipulations that are particularly useful for working with tables and lists. With Simplify, you can perform regular expression based find/replace, fill rows/columns with alternating colors or highlight every Nth row/column, efficiently copy/append data from PDFs or web pages into Excel, identify the unique values in a list, identify and remove duplicate values in a list, merge the content of multiple cells into a delimited list, replicate spanned data, rejoin wrapped text distributed across multiple table rows, combine columns consisting of multiple multi-column data sets into a single data set, remove blank rows, remove whitespace, change case, transpose tables, convert tables to lists, and convert lists to tables.

Version 1.5 adds the Replicate Colors command and makes a number of enhancements to Regex Find and Replace.