VBA/macro to export data from excel to CSV

I have an excel, the problem is that when I save as CSV, it export all blank rows also, (rows that contain formulas or format)
So my exported CSV looks like:
a,b,c,d,e
a,b,c,d,e
,,,,
,,,,
,,,,
,,,,
,,,,
.....

I need that the exported CSV would be just the rows that contain data.
I attach my example excel, if you check first column is a formula.
It could be something similar this solution... https://www.linkedin.com/pulse/20140725234224-54506939-excel-to-csv-export-instead-of-save-as/