I have amended your code to get the results. Please find the details below
- After each filter - Add a read range activity that will read only the visible rows
- Next step would be to write this data table to a new sheet and keep append as enabled
- Repeat the same in the next iteration as well. But keep in mind to exclude the headers when the iteration is greater than 1
- At the end - new sheet will have the expected result
@james.harvey Let me know if you need more details.