@Pradeep Kintali​  Please can you explain in detail as i am new to AA. i have data in datatable

@Yallaling Bansode​  - we can achieve it couple of ways

Excel - open

Loop - All rows in worksheet, inside loop write below if condition

if variablea2]= 'xyz'

Excel - Delete row

you can do it another ways also like Excel as DB or read worksheet as a datatable and filter rows and write final output to another worksheet/workbook.

If this helps you please do Like & mark as "Best Answer" so it will be helpful for others as well. 

Best Regards,

Pradeep.