See the three tabs of the spreadsheet linked here: [url removed, login to view]
Tab 1 ("Raw Data") has a lot of messy and poorly formatted data. I need the data in this tab to pass through a scripted filter as described in tab 2 ("Filter Actions (for developer's reference"). See the notations and comments on tab 2, and message me if you have any questions.
The result should be what is shown on tab 3 ("Formatted Result").
Data on tab 1 will change monthly, but the column headers will always stay the same. Likewise, the columns, formatting, etc. on tab 3 should stay constant.
I need this script to run on tab 1 on a manual trigger.
Tab 2 should be removed once the developer has finished writing the script. I will not be using it.
Let me know if you have any questions.