how to delete alternate rows

[sanjay2210.msl]

hi,

I have data of about 3176 rows,

But after every record one row is blank,

I have to manually delete each blank row.

How to delete it in one Go.

Please Find the attachment

Regards
Sanjay

[Fotis1991]

Hi

Highlight your range(starting in row 3) and use Custom Sort.

[Tony Valko]

I didn't download your file.

Try this...

Let's assume this is your data:

Data Range

	A
2	44
3	------
4	85
5
6	17
7
8	89
9
10	50

Select the range of data A2:A10
Press function key F5
Click the Special button
Select Blanks
OK

Hover your mouse over one of the highlighted cells
Right click>select Delete
Select Entire row
OK