Blank rows

[Thwarted]

I'm sure this had to have been answered before and i apologize for asking it again.

Is there a way to copy rows from a spreadsheet when there are blanks in between and you don't want the blanks

data data data

data data data

How do I copy & paste only the rows with data and not the blanks?

Thanks in advance.

 

[ETID]

highlite all of the data, then..from menu

Use data>filter>auto filter

when the drop downs appear in the header...select any one of them and choose (nonblanks) from the bottom of the drop down list.

highlite all of the data again...then copy and paste

 

[Thwarted]

Thank you!!