I want to import only the agent name and its "Twitter user" but if "F" is empty then ignore it. How? I have tried "Query" but its not working. I want to import it to another sheet in the same general sheet. Thank you

CodePudding user response：

I think you want to create a Pivot, and add a filter on Column F. A pivot creates a new view of your table, with arbitrary rows or columns. And a filter on column F allows you to eliminate rows with empty F value.

CodePudding user response：

use:

=QUERY(Sheet1!A:F; "select A,F where F is not null"; )