Selecting and manipulating data from a sorted and filtered table

I have a table with 15 columns and over 35000 rows. I used MS query to extract this information from our database. With the proper filters in place, the majority of the rows are hidden with about 10,000 remaining. How can I copy, select, separate, etc... the remaining values to a separate sheet? When I copy the table and paste values only on a separate sheet, it ends up pasting the entire table including the hidden cells.

Thanks.

Edit: Just for clarification, the data is currently held in a table.