Transform Data By Example is an Excel add-in that makes it easy to quickly find relevant transformation functions for a specific data transformation task. All you need to do is provide a few examples of the desired output, and Transform Data By Example automatically returns a ranked list of relevant data transformation functions from the large repository of functions it has crawled and indexed. Simply click one of the returned functions to see the results of applying that function on the data.
In the example below, the user has a collection of addresses in the United States in various formats and needs to extract city, state and zip code information for aggregate analysis. The user only needs to provide a few output examples in the column next to the input and then click Get Transformations! Within a few seconds, Transform Data By Example finds relevant transformation functions from a large collection of functions it indexes, and then automatically uses these functions to compose and generate new code that can perform the exact transformation the user specified. All the heavy lifting happens under the cover and is transparent to users. There is no need to write code or leave the familiar Excel interface.