Reports generated from business applications often become inputs to new reports.
You end up spending too much time cleaning them up. Here is a new and unimaginably faster way of doing it – using Power Query.
Estimated reading time 15 min
Estimated time saving huge!
Continue reading Miracle: Instant Report Clean Up using Power Query
This is a log of what I explore and learn.
Power Query – Unpivot Other Columns
Continue reading What did I learn today? Power Query Unpivot Other Columns
The query keeps cropping up very often while I work with customers. There are many ways to handle it. Here are three ways to do it. Simple Copy Paste, using VBA and using Power Query.
Continue reading Combine Multiple Sheets into One Sheet
Power Query is undergoing rapid enhancements based upon feedback received from users. On 29th May another new update was announced.
If you are using Power Query, please update it to get new features. Download it from here. The version number of this update is 2.12.3660.142
Continue reading Power Query : New Update
This is a common activity. Go to a browser page, find some tabular data or report and copy-paste it into Excel. Now you waste a lot of time cleaning up the unwanted things which also got pasted.
If you have Excel 2010 or above (Professional Plus or Office 365 edition),
you have a miraculously simple method available now : Power Query…
Continue reading DO NOT copy paste data from browser. Use Power Query.