I should have added that the sheet I am working with has over 2,000 rows and about 50 columns. While I think "cut/paste" is a good solution, it would not be particularly efficient here since nulls are scattered randomly throughout the active range.
Thank you for the reply though.