Perhaps the least popular section of the add-in, but nevertheless quite interesting. It is responsible for generating data from other data by joining and combinatorial methods.
Each tool has its own practical applicability. So, in order:
Data aggregation tools
I’ll just list them here. Click on the links to learn more about each tool. All of these tools have in common an awesome feature – they are available for free (no restrictions in the free version of the add-in)!
- Merge CSV files
- Combine all open books into one
- Merge data from all sheets in a book into one
- Merge cell ranges horizontally
- Merge all columns into one
- Merge selected cells
- Link builder (merging link text, link itself and hint (overtip) into one
Combinatorial tools
In fact, combinatorial problems are also a variant of combining data, but in their framework the same element can occur many times in the resulting array. This is the main difference from the usual combining.
Phrase permutations generator
Allows you to output all permutations of words in phrases, including the original phrases. Select the list, press the macro, finished!
Linear Combinations Generator
Also known as a word combiner.
Allows you to combine multiple lists of words and/or phrases into long combinations. In other words, multiply words by each other. Actively used in the artificial generation of keywords for PPC and SEO.
All pair combinations in a list
This tool will allow you to list all possible pairs of elements in the list, without counting their permutations as repetitions. The ideal example is to list all the teams’ matches, knowing only their list, considering that each team will play on its own field as well as on someone else’s.