I went to EE and the most recent question seemed like one I could solve. All I have to do is delete the row if it has a non-clear column.
This is one of those that is easy visually but confusing programatically. Looks like this will be on the task picker for a while.