Keep particular values in excel

Hi Everyone,
I have one excel file. in that excel column name is category. I need filter 3 values in that category. Rest of all i need to delete. For example, in that column ‘AAA’,‘BBB’,‘CCC’,‘DDD’,‘EEE’
I need only aaa, bbb, ccc values only rest of all i need to delete. Can you help to solve this issue.

1 Like

Hi @Buvaneshwaran_R,

You want to delete the columns or clear the column’s data ?

Regards
Balamurugan.S

@balupad14 I need to delete the rows

1 Like

Hi @Buvaneshwaran_R,

If you delete row, how can you keep the column value.
But ok. Here is an activity called “Delete Column” . using this you can remove the columns.

And if you want to delete the contiguous rows , you can use this activity.

Thank you
Balamurugan.S

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.