When you deal with an Excel workbook that’s packed with inconsistent entries, missing values, and duplicate rows ... choose how to split it up. Let’s check it in action.