How to delete rows that have a 0 in every column but not rows that have 1 column thats not 0
I have an excel sheet with 8000+ rows of data, there is 18 columns.
each column represents a sample, each row is a different bacteria. so in each cell is the quantity of that bacteria (row) in that sample (column).
i want to delete the rows where each column is a zero (essentially no samples have that bacteria). Is there an easy way to do this? Because doing it by hand for 8000+ rows is taking a long time
thank you!
I have an excel sheet with 8000+ rows of data, there is 18 columns. each column represents a sample, each row is a different bacteria. so in each cell is the quantity of that bacteria (row) in that sample (column). i want to delete the rows where each column is a zero (essentially no samples have that bacteria). Is there an easy way to do this? Because doing it by hand for 8000+ rows is taking a long time thank you! Read More
