Export to CSV only when row contains data

Hello,

My worksheet creates a table with information trough the INDEX & MATCH formula's
When there is no input found, a 0 is show. Most of the times only the first couple of rows contain data, the rest is 0.

I would like to export this sheet to csv but when i do, all the rows with 0 are shown in the csv.

Example:

fname,lname,email,number,date
John,Doe,johndoe@jd.com,C43D2,2016 08 16
Jane,Doe,janedoe@jd.com,D723A,2016 08 16
0,0,0,
0,0,0,
0,0,0,
0,0,0,

Is there a way to only export the rows that are filled??
Say, when a email adress is given, the row marks as "complete" en needs to be exported?


See the example in attachment.
Anyone?

Hi Abbov,

it would be good if you provide sample workbook with desire output...