CODEWITHSUNDEEP
google-sheets
Deedmunkee
Deedmunkee

Reputation: 27

How to exclude rows without value?

enter image description here

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

Upvotes: 0

Views: 63

Answers (2)

player0
player0

Reputation: 1

use:

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

Upvotes: 2

morteza
morteza

Reputation: 153

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.

Upvotes: 1

Related Questions