Remove Rows Where Values in One Specific Column Are NULL/BLANK

[shaheer]

I have data that looks like this: 

Name	Age	Manager
[Null]	20	Anna
[Null]	30	[Null]
Manny	[Null]	Uma
Jamie	22	[Null]

I want to remove all of the rows that have no name, that are [Null]. I have tried using some transpose and filter tools but got very confused as the examples did not pertain to my scenario well.

Sample output:

Name	Age	Manager
Manny	[Null]	Uma
Jamie	22	[Null]

Any help would be appreciated.

[IraWatt · Accepted solution]

Hey @shaheer,

You can select is not null in the filter tool:

[binuacs]

@shaheer as @IraWatt approach is the simple one. you can also do it in different way