A common problem facing Excel users is data wrangling—transforming raw data into a different format so that it can be used for further analysis. For many common data domains—such as date-time, addresses, phone numbers and URLs—sophisticated transformation functions and services exist but are locked up in code repositories such as Stack Overflow, .NET and GitHub, or services such as Bing Maps. For Excel users attempting to perform a specific data transformation task, these functions are difficult to find and use.
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.
Read about it on the Office blog.