This demonstration shows how to use MS Excel Power Query (with a user interface) to go from two excel files of 5 minute data, append the files, remove duplicates, filter AQS-nulled values, and produce a table with summaries by hour, day, and month, and a chart. Most importantly, these steps are self-documenting (leaving an audit trail), eliminate copying and pasting, and result in a reproducible script, all without crashing your computer by trying to filter or even open a file with 105,120 rows.
- Tags
-
