Yes I can manually delete blank cells and I've done that in the past. But it's a pain. If there's a function that will do that automatically I'd appreciate a reference to it if it won't disrupt structure (e.g., shifting cells to the wrong date).