Power Query is one of the best tools available for data cleaning, preparation and transformation. It has a very well-designed UI that can tackle a large number of data problems, as well as in incredibly powerful language (M code, short for “Mash-up”) to handle more advanced transformations and the development of custom functions.
As the Excel BI nightly challenges run by Vijay Verma (a partner with Enterprise DNA) are geared primarily to advanced users, this workout will typically be at a beginner to intermediate level.
How to submit your solution
When you have completed the workout, just post a screenshot of your flow steps and another screenshot of the outcome in the forum thread for that workout.