How to consolidate rows (to get grouped sums) How to reference a cell value from another sheet How to delete blank rows in excel table Simply filter the table by blanks, and then delete those filtered rows