I'm working on an Excel spreadsheet in which I have to delete every alternate row, because it is messing up with my results. It's a set of 4000 randomly generated set of data. Hence, deleting 2000 would take about 30 minutes. Can it be done in 30 seconds using Excel alone and avoiding programming?
Is there any trick to do that in MS Excel?
PS: I want the deleted cell to be empty and not to be replaced with the following entry.