This one I'm having a hard time figuring out....and explaining. It will be easier to understand if you first look at the attached picture.

Example.jpg

I want to search the H column for values that are not zero and basically select everything else except 1 row before and after each value that isn't zero, then delete the other rows. I basically want to create a bit of a buffer between the non-zero numbers. It is a bit tricky because as you can see in the picture there can be two value in the H column one after the other. There will never be more than 2 values in a row in the H column. I have 270,000 rows across multiple tabs to go through, so getting this to work would be nice.

Thanks to anyone in advance for lending a hand!