Filtering empty column and removing whole rows

Hi Community,

I would like to ask about the filtering of empty column for specific data header and removing the whole row if the chosen column is empty.

I have attached file and screenshot below for your reference.From the screenshot below , i want to know if there is empty / blank in the column invoice. If yes, remove the whole row .

May i know how we build the workflow to fulfill this requirement?

Invoice.xlsx

Common Use Cases

Accepted answers

justamfam

Hi @jacob_94 ,

The data cleansing tool should allow to you accomplish the same thing.

K/R,

JAF

All comments

bpatel

hi @SH_94 ,

you can use the filter tool with IsEmpty([invoice]) to achieve this.

hope this helps

SH_94

Hi @bpatel ,

Thanks a lot for the great sharing.

May i know if we can use formula tool in this case ? Or any other method beside the filter tools?

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703