=QUERY({programmatic_spends!A2:G200;email_spends!A2:G200},"select * where Col3 <>''")
The result should look like this More information about the query command can be found in the Google Sheets Documentation.