You could add headers in row 1 and then apply data|filter|autfilter.

Filter to show the blanks and delete the visible rows.
filter to show 0's and delete those rows
remove the filter (data|filter|autofilter again)
and remove the header.

UT wrote:

Hi,

In a worksheet, on sheet 2 I have survey data imported from sheet 1.
However there are some rows with "0" value and blanks in between the rows of
data. I want to display only the non blank or non zero cells.

Example of My Sheet 2:

ROW COLUMN B
1 This is my first online course
2 0
3 <blank
4 Enjoyed the Course

Would like the data to appear like this:

ROW COLUMN B
1 This is my first online course
2 Enjoyed the Course

I tried the formula below on sheet 2 but it gave me "too few arguments for
this function" error message.

=IF(ROW()SUMPRODUCT(--(Sheet1!AR$9:AR$5000<0)),"",INDEX(Sheet1!AR$9:AR$ 5000,SMALL((Sheet1!AR$9:AR$5000<0)*SUMPRODUCT(--ISBLANK(Sheet1!AR$9:AR$5000))+ROW())))

What other function can I use to address this problem?
Thanks for the help.
UT

--

Dave Peterson