I'm working with a large spreadsheet. It consists of physical activity values, ranging from 0 to several thousand per minute.
My task is to delete values of 'non-wear time', which means deleting consecutive values of 10 or more "0's". But not if there is 9 or less. Is there any function or macro that can do this automatically?

I've added a photo as an example, showing a marking of cells that are to be deleted, while underneath there are cells that should not be deleted. Any help on the matter would save me a ton of hours.

example.png