Skip empty row and fetch values from other rows

Hi Team,

My excel will have number of columns and rows with values.There will be one row space between each row of data. When i run my macro a csv file will be generated. In this case my macro should skip the empty row and then check the next row where values are available.

In my excel column A and Column B must have values excluding the empty rows.

Kindly give me a code for this

Regards
Dhivya

can you attach a sample file with desired result (your macro included) ?