Another useful feature provides the ability to split columns--extracting first and last names into separate columns, for example. In our tests the program worked smoothly and quickly, even with large tables, although the lack of a help file might give some new users pause. Overall, we see DigDB as a potentially significant help to people who work with large spreadsheets.
Use this Excel add-in to remove duplicates. Remove by list matching or key fields; do Access-like query, aggregation, join; simplify pivot table with a roll-up that outputs in simple list; enhance pivoting and subtotal to aggregate in 21 statistical functions such as median and count of unique values. Use this add-in to find and fix broken links; set complex filters; filter blank, exclude, invert, filter within filter; merge or join tables; sort list by multiple levels; special sort by text, color, or style. Use this add-in to fill range by random values or linear series; delete, insert by intervals; convert date values, data types, and cases; extract valid e-mail addresses and filter result; append tables to form a master list; split table by values in columns or number of rows. Use this add-in to mix, match, combine sets of values; transpose, combine, split, trim columns.
Version 18.104.22.168 may include unspecified updates, enhancements, or bug fixes.