Trick 006 Processing data formatting in an Excel table with Power query

     As we work, we may encounter data sources with many different formats. To facilitate data processing or reporting. We need to homogenize the data before we do that. In excel we can use power query to do this.

    With an excel table formatted with many different styles. Now that we need to clean up the formatting, here's a good example of that.

The trial has a limited time. 

Full code, step and full support version. Buy it