1. make a new column one to however much.. 2. Sort on your first data column and then highlight and delete the cells over that certain value (they'll be all bunched together so it'll be much easier this way). 3. reiterate with the next data column in turn until you've done all six columns. 4. Resort on the new column you made in step 1 to get back the original order. . If the order doesn't matter you won't need steps 1 and 4.