How to filter data in a particular excel sheet based on a column and save only the valid rows into the same excel sheet

How to filter data in a particular excel sheet based on a column and save only the valid rows into the same excel sheet?

Hi @shrganes

You could get you data into a datatable, filter it according to your needs and copy into the same sheet.
An example of achieving this is in this post:

what about if its a CSV file ? The format of the csv is scattered,For Example in A1 filled then from A8 column the actual values appear which are imprtant.