CODEWITHSUNDEEP
google-sheets-formula
Dip Chakraborty
Dip Chakraborty

Reputation: 29

remove blank lines in google sheet using formula

I have a google sheet with some contact info. Where some categories like 'promotion team', 'creative team'. I have created another sheet, and imported that information, put names under the category.

I have given a formula like this -

=IF(EXACT("Promotion & Marketing",Sheet1!E2), Sheet1!A2, " ")

but some line remains blank, how I can check, if this if statement false, then skip the line, don't leave it blank

Upvotes: 0

Views: 345

Answers (1)

Krzysztof Dołęgowski
Krzysztof Dołęgowski

Reputation: 2660

You can filter the content of A column.

I can't see your exact data so my answer may be not super precise but I think of something like that:

=filter(Sheet1!A2:A,Sheet1!E2:E="Promotion & Marketing")

This formula should display all the cells from A2:A range when there's "Promotion & Marketing" in corresponding row of E2:E column. With no blank rows.

Upvotes: 1

Related Questions