How do I remove blank rows in a column

[Rasmus]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi

I have at column with 20.000 rows of data. Every second row is blank. How do i remove all the blank rows.

This is the data as it looks now
56

89

89

65

And i want it to look like this
56
89
89
65

Hope someone can help?

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi

I have at column with 20.000 rows of data. Every second row is blank. How do i
remove all the blank rows.

This is the data as it looks now
56

89

89

65

And i want it to look like this
56
89
89
65

Hope someone can help?

Have you tried sorting it?

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi

I have at column with 20.000 rows of data. Every second row is blank. How do
i remove all the blank rows.

One way:

Select the column.
Choose Edit/Go To.../Special...
Click the Blanks radio button and click OK
Choose Edit/Delete...
Select the Entire row radio button and click OK

 

[Rasmus]

Hi

Thank you very much for the info. I solved the problem by using Edit/go to.../special.

Have a nice day
Rasmus