HI COLTS12OG

Run the Delete_Empty_Rows Code...it does it's thing (deletes all empty rows) and then Calls Merge_Rows which does the actual merge of the records.