Excel B: Multiple 5-min Files Cleaned Appended Summarized Charted
From ITEP Team
Use of this service constitutes agreement with the terms of NAU's Acceptable Use Policies found on this site: https://nau.edu/its/policies/
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.