A nice little bit of Excel macro magic allows you to delete rows if a particular column is blank.
I deal with data sets that are always scrambled, but usually in different ways. This precludes the use of macro-scripting programs (like my personal favorite, trusty old Automate 4) because the patterns just different enough for pre-programmed key macros to fail.
Thanks to this little macro by Chip Pearson gets around the problem nicely. Thanks, Chip!