Between each you can notice column, these are blank cells. I am interested in having these blank cells removed. To do so, do the following, Highlight just the range of data containing the blank cells.