Apr 13 2021 11:17 AM
Apr 13 2021 01:42 PM
Perhaps data in the sample file is already partly cleaned. For the raw data you may add helper column as
With that you need only rows where the second is equal to zero. How to remove it depends on how dynamic your data and which functionality of Excel do you use. In simplest manual way filter all but zero
select all rows till end of the range, Delete rows
In general you may use Advanced Filter or Power Query to copy filtered data into another location or VBA to remove extra rows in place.