Excel that allows you to "filter" data as necessary. On the raw data sheet, select the column you would like to use as your filter criteria. You should see the whole column highlighted.

Screenshot

Now, from the "Data" menu, select "Filter" -> "Auto Filter".

Screenshot

You should see like a "drop down" menu added to the top of the selected column. Now from that column, filter on "1". This will show only those rows where the selected column has a value of "1" (you can filter on anything, other "1". "1" is just an example in this case).

Screenshot

Please refer to the following web page for help with Excel filtering: http://www.rdg.ac.uk/ITS/info/training/notes/excel/filters/#FilNum