delete rows in a patterned sequence

I have a worksheet with about 15,000 lines of data. I wish to retain every fourth row, and delete those in between. So, for example, I wish to retain rows 27, 31, 35, 39, etc., and delete what are now rows 28-29-30, 32-33-34, etc. I do not want blank rows appearing in the final, edited version. Is there a simple way to do this?

Thanks!

This procedure will leave every 4th row, deleting the 3 rows in between, based on a couple of assumptions. First, it starts at the last row in the spreadsheet that has a value. Second, the row above the last row in the spreadsheet that has a value will be the first row that is deleted. Third, it will repeat until it gets to row 1. Let me know if you need assistance modifying any of these assumptions to fit your need.

Please Login or Register  to view this content.

HTH

Jason