How to read/extract data from a csv file?

i have a requirement where I have to extract the data from a csv file to a cdt/database.

Here row1 has fields and row2 has the values.

Again 4th row has  few more fields and 5th row has the values.

I tried using import to database v6 which works only for row 2.But I need to work for row 5 as well.