Move cells adjacent to each other (delete blanks)

I have a massive data file that has about 100k rows and I go out to column "KS". I have random blanks in between my data and I need to move all the data so it is adjacent to each other. The data on row "1" needs to stay on row "1" and if its on row "2" it needs to stay on row "2". I just need to delete the blanks between the cells. Thank you for your help.