Select huge data and remove blanks - How

I have 85k cells in a column in the below format.

Q1: How to select all the 85k cells when there is a blank cell below each cell?

Q2: How to remove blanks only? (not duplicates)

Note: I know how to remove blanks. only problem is i am not able to select data in 85k cells where there is a blank cell bottom of each cell.

41.616211;-75.498047;41.660156;-75.454102

31.772461;-95.888672;31.816406;-95.844727

40.03418;-74.926758;40.078125;-74.882812

39.111328;-77.695312;39.155273;-77.651367

38.276367;-81.606445;38.320312;-81.5625

39.462891;-83.71582;39.506836;-83.671875

38.891602;-76.640625;38.935547;-76.59668

39.990234;-76.772461;40.03418;-76.728516

40.649414;-75.27832;40.693359;-75.234375

61.699219;-150.073242;61.743164;-150.029297

40.078125;-94.833984;40.12207;-94.790039

34.277344;-118.916016;34.321289;-118.87207

27.773438;-97.426758;27.817383;-97.382812


Huge Thanks!!

Assumed your data in ranges A1 and down, put this in Cell C1 and copied down:

=IF(ROW()-ROW($A$1:$A$30)+1>ROWS($A$1:$A$30)-COUNTBLANK($A$1:$A$30),"",INDIRECT(ADDRESS(SMALL((IF($A$1:$A$30<>"",ROW($A$1:$A$30),ROW()+ROWS($A$1:$A$30))),ROW()-ROW($A$1:$A$30)+1),COLUMN($A$1:$A$30),4)))

or see the file

Regards

Thanks for your time Azumi


Actually, i did it in a different way.

1. Highlighted the cells that are blank by conditional formatting

2. Sorted ascending or descending and selected cells that has data simply by clicking shift+command+down arrow.

Solved !!!!