I have a serious problem with a huge Excel sheet which I need to remove blank rows from.
My problem is that I cannot use the classic F5->Select blanks->delete, since some of the fields on not blank rows are also blank.
In the above example, how would I go about deleting rows 2, 3, 5, 6, 8, 9, 11, 12, 14, 15, 16 without f.x. C7 ending up in C2?
Selecting the blank rows individually would be too time consuming in the real Excel sheet, since it has over 35,000 rows, and this stunt is not a one time thing.