Automatically Apply 2 Filters For 2 Columns And Get Results Compiled In Single Excel Or CSV File

Use filter for 2 columns of a CSV file, column A and Column B for certain words. Say I apply a text filter: contains "word1" or contains "word2" to Column A. Then I get the results. After that, I remove the filter to Column A then apply the same filter to Column B. The thing is, I don't get the results in Column B, instead, I get the cells in Column A wherein Column B is filtered PHOTOS BELOW:

The data that I get for this filter are:
And Word1 you
Word2 is blank

Apply filter to Column B, get the cells filtered in Column A:

The data that get for this filter are from Column A (which are cells filtered from Column B filter)
And Word1 you
Is the blah
Word is all

The results should in a single Column for both filter:

I have more than 100 files that needs to filtered this way, is there any way I can do this automatically?

Here is what the file looks like:

The results I hope would be possible:

Automatically without having to open all the files and have the results of all of it in 1 single Excel file?

----or----

If the above is not possible, open each file and automatically apply the filter into a column in just 1 click and without having to type the same filter for each column.

I found a code to combine all CSV files into 1 Excel file, but half of my files has more than 500k rows and the Excel's limit for rows is around 1million+.