I have a dataset about 1000 rows long. Some of the rows will have a "0" in a certain column. If a row has a 0 in that column I want to delete that row, and compile the remaining information on a separate worksheet.
I've attached an example of the "raw data" and the cleaned data.
Thanks for your help. (PS I don't know how to use Access so I'm using Excel).
Bookmarks