How to filter by group, selecting only cells that have data, filtering out empty ones?

Question

Google Sheets

How to filter tables by 1 group (See doc), only taking into account companies that have data? That is, the output should contain the data of group 1 in which the information in the "transactions" column is filled in.

An example of a document with an example of the result that I want to implement is attached.

Document

Thank you in advance for your help and answers.

Answer 1

=FILTER({C5:C20\A5:B20};C5:C20=1;B5:B20<>"")

Example in Spreadsheet https://docs.google.com/spreadsheets/d/1aoKuLtRkCE...