Trick 006 Processing data formatting in an Excel table with Power query
On Sale
$999.99
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.