How do I delete blank rows (rows alternate data, blank, data, etc
On Jun 26, 1:10 pm, ncochrax
wrote:
I am looking for a shortcut to delete multiple blank rows (rows alternate as
follows: data, blank, data, blank, etc.) Is there a way to delete the blank
rows between the data rows without having to select each row individually
using CNTRL-C?
Selecting all of your data and sorting it by any of your columns
should move all of the blank rows to the bottom.
|