cleaning up data

Depending on what your worksheets look like, you may need to apply some VBA if your worksheet is large. Perhaps if you provided a sample worksheet with specifics, someone here may be able to develop some code for you.