With hand-entered data, it’s not uncommon to see messy data like this:

Screen Shot 2014-09-25 at 10.33.46 PM


Select the variable, then “Clean”…



…then drag the categories into the correct positions…



…so now your data will look like this:

Screen Shot 2014-09-28 at 5.46.17 PM

Or, if you clean a Numeric variable, you can use the “Variable by Filters” dialogue (see the “Create” section above) to indicate which data should be ignored (for example, numbers above or below a certain threshold).