libreoffice calc find and copy all matching data in rows

[PbWerk]

Would like to know if there is a way to Find and then Copy all matching data in a row. I have used the Find option but in only selects the one column that the search term appears in.

I want the find the search term and the copy all the rows and columns that are included in the search to copy to a separate data base.

I am trying to extract only payments that I have made on a weekly basis from my bank statement .csv file

[JohnSUN]

Use Data - More Filters - Standard Filter and Copy results to in Options

This shows how to copy non-empty values ​​to a new range. Of course, you can use other conditions to solve your task.