Excel 2007 Please help!

Hello,



I am in Excel 2007. I have data from a formula returned on approximately 200 rows in column K. Because the forumla is only true for some rows, there's only 83 rows that have data in them. I need those 83 cells to populate on rows 1-83 in folumn L. In other words, I want the same information, but do not want any of the spaces, but I can not delete the rows. Below is an example:


30503 30503
30607
30607 30608
30608 30569
30569 30500
30500 30394
30394 30600
30600 30538
30538 30538
30538 30095
30095 30168
30168 30121
30544
30602



30121
30544
30602


Please help me!

Thanks!